Jerry, I like your suggestion. I wish I would have thought of that. So to
make sure I follow you, you are basically saying enter the job # (09-8478)
and the lot # (P/1.2) seperately, then I can always concatenate them later on
a report if I want. Thanks for the idea. That should work.

Jerry Whittle wrote:
It looks like that job number has different 'parts' that have meaning. If so
you'd be much better of having them broken down into 3 or 4 different fields.
Then recombine them afterwards. Then you could use things like input masks
and validation rules to ensure that the data entered is most likely correct.
I have what I believe to be a very simple problem for all of you who know
Access better than me. I am using Access 2007 and have a field in my table
[quoted text clipped - 8 lines]
Thank you for the help. I already figured out how to make sure that caps get
used instead of lowercase.

--
John 3:16 "For God so loved the world that He gave His only begotten Son, so
that whoever believes in Him shall not perish, but have eternal life"

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201005/1