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.
 
Back
Top