Quick validation rule question (1 Viewer)

[sgtblitz]

Hi there guys,
I have a reference field in my DB that can either be CD followed by 7 numbers
e.g.

CD/1047294

DV followed by 7 numbers

e.g. DV/1948402

IH followed by 7 numbers

e.g IH/3742058

and MS followed by 7 number

e.g. MS/0683723

Can anyone tell me of an input mask or validation rule that I could apply to ensure this?

Thanks

 

[Kiwiman]

search "input mask" on Access help - this will explain it and give you options on what to apply. The input mask can then be applied against the control on your form