Format a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Relationships 3
Calculated Field in Db Table 14
Capitalize first letters in field 5
Sorting in a Report 2
Input Help 1
Access Access anti-trim?? 0
Text Field for Tracking Number - Ignore the dash 12
Currency Field 5

Back
Top