Format a field

A

Aurora

I am using Access 2003
In my Db I have a field of 4 numbers, a dash and a letter. (ex: 2,000-A)
How do I format this field so that no matter what is typed in (ex: 2000-a) -
the field will look like the first example all the time?

Aurora
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Copy previous record into form field 0
Modern equivalent of Autotext in Word? 0
Mail Merge Directory Conditional Page Break 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
VBA - exporting serial letters to single documents 0
Delete all data after a symbol in a field 0

Top