how to check before update after specific format for input field

[Susy]

Hi guys,

is it possible to check for input format before leaving field..

The input field should follow this format:
AR17XX9999

where:
AR stands for Area Report
17 is for the year: 2017, 2018, 2019, 2020...
XX two letters for the geographical area... 01, 08, 12, ...


9999 for number for a maximum of 9999 reports over a year

I will really appreciate if you could help me with this...

Best regards!

[RuralGuy]

Sure. Can you use code like Left(), Mid(), etc.?

[June7]

Are you using InputMask property?

Or have users input parts into separate textboxes and use code to concatenate.

[Susy]

Hi guys,

I totally forgot about left, right mid...and even len... so, I create an afterupdate event with msgboxes telling exactly where the error is...

Thanks a lot again.

[RuralGuy]

Use the BeforeUpdate event and set Cancel = True if it does not validate. It will hold the cursor in the same field unless you let it by.

[Susy]

Thanks... Set Cancel = True? Ok, will try then.

[RuralGuy]

Great! For the record, Cancel = True. No Set involved.