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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lost Ivan - 27 Sep 2006 20:44 GMT

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?

Reply to this Message

Douglas J. Steele - 27 Sep 2006 20:58 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>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
[quoted text clipped - 5 lines]
> field
> format to keep the input format on the form and the table as well?

Reply to this Message

Klatuu - 27 Sep 2006 22:26 GMT

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.

> 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?

Reply to this Message