Hi All,
In my form, I have a field where I would like the user to comply with one of two format.
The fields name is : TargetAltitudeSID
The format possible are :
- FL and 1 to 3 numbers (e.g FL1 or FL12 or FL458 ...)
- The field has to be a number < to 99999
I haven't found much on the internet but I have tried a few things.
I tried :
- Input mask: "FL099" or "99999"
- After update event :
Me!TargetAltitude.format = "FL099"
or Me!TargetAltitude.format = "99999"
- After event :
Format([TagetAltitudeSID]) = Format(FL099) or Format (99999)
I'm open to any suggestion, advise.
Thank you for your help,
Mat
In my form, I have a field where I would like the user to comply with one of two format.
The fields name is : TargetAltitudeSID
The format possible are :
- FL and 1 to 3 numbers (e.g FL1 or FL12 or FL458 ...)
- The field has to be a number < to 99999
I haven't found much on the internet but I have tried a few things.
I tried :
- Input mask: "FL099" or "99999"
- After update event :
Me!TargetAltitude.format = "FL099"
or Me!TargetAltitude.format = "99999"
- After event :
Format([TagetAltitudeSID]) = Format(FL099) or Format (99999)
I'm open to any suggestion, advise.
Thank you for your help,
Mat