Can a field value be customized?

  • Thread starter Thread starter stripedfrog
  • Start date Start date
S

stripedfrog

I have account numbers that the first two letters are always the same
followed by numbers. Can I set the field to default the letters so that the
user only needs to enter the numbers.


(Ex:) Account number is BC12345. I would like the field to already have
the "BC" show up so the user only needs to enter "12345".

Any help would be greatly appreciated.
 
The BC is the same for *all* accounts?
If so, just leave it out of the field, and put it in a label.

You can print it in a report as:
="BC" & [Account Number]
 
Thanks Allen!! I appreciate you responding.

Yes, they are all the same so that's what I'll do.

I'm new to Access and therefore dont' know all it's capabilities.
 

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

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Simple Access Project - Almost There Just Need Some Help... 2
Populate 'To' recipient on custom mail form 0
Field Default Value 0
AutoNumber 8
fund1, fund2, fund3 - repeating field question 1
Check TEXT BOX entry agains table info or EXCEPTION values 5
Format a field 1

Back
Top