Text Box Alignment

[VBADb]

Good Morning Everyone -
I have a text box which holds a production lot number which just the date and a 3 digit box # in the format "040206-001". It has a format of "@@@@@@-@&&" so it will insert the "-" if just the 9 digits are entered. After the user saves off the first entry I want to load the text box with "040206-0" so the user only has to enter the last 2 digits on subsequent entries.
Unfortunately the format seems to be right justified so as soon as the text box loses focus the output shows "04020-6-0" inserting a new dash. Is there any way to get the format to be left justified?

 

[fneily]

Place an ! in front of your format. This makes the cell fill right to left instead of left to right.

 

[VBADb]

(laughing) I don't know where you came up with that nugget of information but thank you so much. I've been looking thru online help, our Access Bible and O'Reilly books and never found it. Thanks again!!!! George

 

[fneily]

It worked??? I was just guessing. Actually, it's on page 134 of Microsoft Access 2000 Bible by Prague and Irwin. That's the problem with applications like Access and Excel -you need to buy about 10 books to find what you want.