Can a field value be customized?

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.
 
A

Allen Browne

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]
 
S

stripedfrog

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