Text Box control and character limit?
**The field in question is in its own table because it is a memo field that gets changed regularly in production. The production environment has this as a bound control but I am trying to implement unbound controls to avoid excessive record locking.**
Is there some limit on text controls regarding length of text? I cannot find anything by googling or searching this forum
Thank you for taking the time to report an issue.
What's wrong... Please write below.
It does not allow me to enter any information beyond just one line. Is there any way to extend the character limit of this field, or even better, make it unlimited?
I only want the user to be able to change the data in this text box control if they are on Page 1. If they are on any other Page, then I would like to Lock the text box control.
If there was a Got Focus event for a Page then I could do what I need; but there isn't!
Is there a way to determine which Page of my Tab Control is active
However, I don't want or need the user, to see this 'control character.
Both options result in automatic population of the control with a Currency value. I would like a Command Button control to be Enabled - True or False depending on the value. as per the code below.
What do you want to do: Add a bound text box, Add an unbound text box, Add a calculated text box, Understand text box properties.
1) Some text
2) Some text
3) Some text.
Right now I have a text box that has =1 as its control source but I need it with the text it self not in its own text box.
In the text box I want to add a number its control source is =" " & [BasicJobSteps]
Here is my control source expression that works:
=IIF([srptInvoiceDetail].[Report]![HasData], Nz([srptInvoiceDetail].[Report]![txtSubTaskTotal],0),0) +
IIF([srptAddFLR].[Report]![HasData], Nz([srptAddFLR].[Report]![txtFLRTotal],0),0) +
If I add the 4th IIF for the last subreport I exceed the 256 character limit of the expression field.
How can I work around this limitation?
I can envision two ways to accomplish this:
1. Perform the IIF in the subreport to ensure that a valid value is passed to the main report. If the subreport has records, the value would pass through correctly. If the subreport has norecords, the HasData flag will reflect that and the value will be set to zero.
2. Perform the IIF calculations in VBA in Report_Open (or some other report event). The IIF calculations would be performed in the Report_Open event and pass the total to the unbound text box in the main report.
I need to limit Job number input in Job text box, if Order text box is empty? For example - I need, if Order box is empty, then allowed numbers in Job text box is only 500, 501, 502.
If Order text box has a record, then Job number input no limited.
Here's the only code on any of the control events:
Private Sub cmbDefendant_Change()
Debug.Print "text: " & Me.cmbDefendant.Text
The list of possible values can be huge so I'm wanting to wait until the users typed 4 characters in the combo before I go get a the list of values from the database. I've done the same thing on another field on the form so I don't understand why its a problem on this one. I've tried changing the limit to list property for the control but that didn't help. On the other control I have it set to Yes to limit and it works fine