Input Masks - table or form level

[ibcormac]

I have read many posts on here regarding usage of input masks but have yet to find answers to a few questions.

Should input masks be used at the table level, form level or both?
I believe at the form level it is possible to provide the user feedback on errant input, but not at the table level. Is this correct?
If this is so, sounds like justification for form level input masks over table level.

What are the advantages/disadvantages of storing the mask characters versus not storing them?

Appreciate any input on this. Thanx.

[CJ_London]

since users should never have direct access to tables, applying input masks or formatting in tables is unnecessary from that perspective - although using them whilst developing might have benefits

So only apply at form level.

The only potential benefit at table level is whilst developing is that the format and input mask properties will be copied to any new control created - although if you subsequently change the table, this will not update the already created controls.

I don't know, but for access to apply an input mask and/or formatting is a task that takes time - I guessing this may have a very small impact on db performance

[ibcormac]

Ajax
Thanks a lot!