Can a field value be customized?

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

 

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

 

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