input mask, validation rule or other options

[Kizer]

Hi, I am working on a continuous form for data entry reasons. One of the fields is a policy number(PolicyNu mber) field. The first character of the policy number(which can only be B, C, D or E). That first character also represents how long the policy number can be. B should only be 7 numbers long(only numbers, no letters), D should only be 5 numbers long. I would also like the first character of the field to populate a company name in a separate textbox(Company ). B would represent OEM and D would represent OED.

Any suggestions are greatly appreciated.

[Seth Schrock]

I think that your best bet would be to test your input via VBA code and not through the Validation Rule property. You will just have to test what the left character is and based on that check the other criteria. You can also select your company based on your testing.