Lower Case is shown in form textbox when Upper Case in Table!

[pj.field]

Hi, guys<br>I've had lots of help from some of you out there, and I've overcome virtually all of my original problems, thanks to that help.<br>One problem remains, however.<br>I have some tables, whose text data is ALL Upper Case.<br>I have a form which has bound text boxes to fields in these tables.<br>Some of the Form Fields display as Lower Case. I don't want to have to convert every text box on the form using VBA UCase or UCase$ - the overheads would be quite large.<br>Can anyone throw a little light on this, please?<br>Best regards, Pete

[ranman256]

It shouldn't convert case unless you tell it to.
Yu can convert in the source query.

[CJ_London]

Or you can set the format property of the control to < for lowercase and > for uppercase

[Micron]

Your table field(s) could be formatted for one case or the other (@> or @<) OR your form controls are similarly formatted OR your data is actually entered that way. In the latter case, your data might be one case or the other but the field(s) have a format which alters what you see. You have to examine the field and control formats to see if that is over-riding (altering) what the actual data is.

If your data is actually mixed format and you want to change the data (e.g. dog > DOG) you can run an update query against those fields.

[pj.field]

Thanks, guys. I had the '>' in place on the Tables, but not on the Forms. All good now.
Thanks again.
Regards, Pete

[CJ_London]

Strongly recommend you do not use any formatting in your tables - it disguises what you actually have