Hi,

I'm trying to create an input mask for my AutoNumber field. The format of the field should be B_S____, which is:-

B, a capital letter, S, and four digits which generate by Access.

I tried B>LS0000 but it result in e.g. B>LS0001, B>LS0002, etc. rather than allowing user to type in the capital letter between B and S. I have no idea how the input mask should be, could anyone help me PLEASE?
Thanks a lot

You can't use an input mask on an autonumber field, only text fields.
You can create this sort of numbering using formulas when you run a form or report. Have the user unput the characters you want in one field, then have a second field on the form show the user your scheme based on a concatenation of the field they just entered and the autonumber field.

In any event you won't be able to manipulate an autonumber field like this. Am I right folks?

HTH

mmcdonal