That looks rather complicated. I would say, take a hint from the way FoxPro stores dates: they are stored in a standard format (in this case, YYYYMMDD, in 8 bytes (not very efficient, but that is not the point)), but depending on some SET commands, the data are shown in different formats.
I think that would require unbounded fields (no .ControlSource), and the data would have to be converted to and fro, on Form.Refresh() and on saving data.
>I need to create a table and form that will allow choices in different formats for certain field values.
>
>For example:
>
>Social Security Number could be:
>
>999999999
>999-99-9999
>999 99 9999
>
>A date could be:
>
>YYYYMMDD
>YYMMDD
>MMDDYY
>MMDDYYYY
>
>A full name could be:
>
>Last, First Mi
>First Mi Last
>Last First Mi
>First Last
>
>What would be the best approach for this?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
