Formatting entries into fields

[marksmithhfx]

Hi, I'm just starting to develop a database in LC (using SQlite) and I have a few questions about LC field entries. Is there a library (or document) around that can help you do such things as validating the length of an entry, formatting an entry, etc? Here are a couple of examples:

In Canada a postal code has the form LNL NLN where L is a letter and N is a number. So, for example, my postal code is R3G 1C6. So, when getting postal code information in a field it would be nice if, as the user typed, it validated each character to make sure it was the correct type (beeps if not) and auto-inserts the space

Another typical example is a phone number field, where you have something like ( ) - perhaps in light grey in the background, and then as the user types the numeric digits (with the field only accepting numbers) it skips from location to location as you type

Dates are another example, where the background might show (in light gray) MM/DD/YYYY and the user can type numeric digits for month, day and year with the entry validating that month can only be 01-12, day can only be 01-31 etc.

Social insurance numbers, credit cards and the like also often have defined formats and ways of validating the input.

Is there a LC package of smart entry field validations and formats already floating around, or a discussion posted somewhere on how to do this?

Thanks, and apologies for the long post

-- Mark

[Klaus]

Hi Mark,

hmm, not an easy task!

Maybe this could be of interest for you:
http://droptools.sonsothunder.com/


Best

Klaus

[marksmithhfx]

Hi Mark,

hmm, not an easy task!

Maybe this could be of interest for you:
http://droptools.sonsothunder.com/

Klaus, thanks. Just what I needed to get started. I've installed droptools and it looks like there is a lot to explore.

-- Mark