Data in field off-center

[Pikeboy]

I've a form I created from a query using the wizard. All of my data looks good except two of the columns. In those, the data in the fields is off-center and until I made the text box larger both were somewhat cut off. There is nothing I can find that I have done to cause this. Any ideas what it might be? In both fields the character length is only going to ever be but 3 characters so enlarging the text box really isn't too desirable.

[June7]

Text left aligns by default. You can change it to center. Textboxes shouldn't have to be that large for only 3 characters.

Why are numbers centered? The default is right alignment.

[ArviLaanemets]

Probably those 2 fields have trailing spaces, i.e. not "CHC" but "CHC ".

[Welshgasman]

Check the lengths?
Use Trim() function if you have spaces, or remove them to start with.

[Pikeboy]

Tried trim (record source - query), confirmed text length at 3, and text align set to center. I'm stumped.

[Welshgasman]

Upload db with enough to see the issue.

[Pikeboy]

No matter how much I try to pare it down I get size error message.

[Welshgasman]

Compact and repair, then zip.
is it still too big then?
We only need enough to see the problem, so that form and the data/objects that support it.

[Pikeboy]

Sample.zip

Please give this a try. Thanks in advance.

[Bob Fitz]

Change the Scroll Bars property to None

[Bob Fitz]

Change the "Scroll Bars" property of both the textbox controls to None rather than Vertical.

[Welshgasman]

Change the "Scroll Bars" property of both the textbox controls to None rather than Vertical.

Nice spot Bob.
That property defaults to None when you add a control.

[Bob Fitz]

Nice spot Bob.

Thank you for your kind words. More a "Lucky" spot really, I think. I had the form in design view, showing properties. As I moved from the Age control to the Team control the Scroll Bars property changed. Not usually that vigilant

[Minty]

Nice spot Bob.
That property defaults to None when you add a control.

If you use the wizard to add controls to a new form it varies, and seems to depend on the length of the field and any data already stored in it.

[Pikeboy]

Worked perfectly, thank you very much!