Special Input masks on text fields

I've had a few people asking about the best way to handle input masks (pictures in VFP speak).

There are a few special input masks that I think are worth mentioning as they are time savers.

Convert all input to uppercase:
@!

Accept alpha characters only:
@A

Accept alphanumeric:
@X

ISO date YYYY-MM-DD:
@D

Integer value with maxlength,minvalue,maxvalue:
@I10,100,1000

Double value with maxlength,maxdecimals,minvalue,maxvalue:
@F10,2,0,10000

Valid email address:
@E

Any regular expression starts with a ?. The example below validates an email address:
?\\b[A-Z0-9._%+-]+@[A-Z0-9.-]+\\.[A-Z]{2,4}\\b

VFP-style picture characters:
!
A
9
X

Would it be possible to also have one for TIME entry?
Maybe something like @T, which would Default to the System Default Format,
or @Thh:mm:ss,24 for a full "European time" entry.

wOOdy

Quote:

---

Originally Posted by woody-soft

Would it be possible to also have one for TIME entry?
Maybe something like @T, which would Default to the System Default Format,
or @Thh:mm:ss,24 for a full "European time" entry.

wOOdy

---

Yes that's a good idea.

Quote:

---

Originally Posted by barrymavin

Yes that's a good idea.

---

I've not known wOOdy (for 20+ years, right?) to have bad ideas, fwiw. :)

Hank

Quote:

---

Originally Posted by HankFay

I've not known wOOdy (for 20+ years, right?) to have bad ideas, fwiw. :)

---

Well said.

Rolf

Hi Barry,

Can two or more input masks be combined at the same time?
For example, can you set all characters to upper case and only use alpha characters (numeric characters not permitted)?
@!, @A

Cory

Cory,

You can't combine @ picture functions.
If you require a new picture character to be added to Lianja, please log this as a enhancement request.

Hi Chris,

Thank you for the confirmation.

Cory