How do I set a field format to remain the same when store in a tab

[Guest]

I have a payment form linked to a payment table. I have set up the input as
"0000-0000-0000-0000" and works great when you are entering the credit card
information; however is stored as "0000000000000" after I closed th epayment
form on the form view and the table as well. I need to keep the "dashes"
between each set of numbers for report purposes. How can I set up the field
format to keep the input format on the form and the table as well?

 

[Douglas J. Steele]

Take a look at the Help file on the InputMask property (with your cursor in
the InputMask, hit F1)

You'll see that if you put ";0" at the end of the mask (without the quotes),
it'll store all literal display characters that are part of the mask, in
addition to what you actually typed.

 

[Guest]

Rather than take up space in your table with all those extra dashes, do the
formatting in the report or anywhere else you want to display the number with
the dashes, including the form. Form and report controls have a Format
property that is used to determine how the data will be seen.

Try not to confuse how you store data with how you see it.