Formatting text in a table.

[Curt Hand]

I have a column in a table that is text and has an input mask. When I enter
the data from the form to insert into the table it does not use the input
mask.
i.e. without mask ugaCO1cfco01 is the way it is entered into the table.
the correct way should be u-ga-CO1-cf-01.

What I want to know is how I can change the date to the correct format
without doing it line by line?

Thanks,
Currt

 

[KARL DEWEY]

Maybe you have a misunderstanding of the use of mask.

If your mask is a\-aa\-a99\-aa\-99 and you type ugaCO1cfco01 it will disply
u-ga-CO1-cf-01 but it does not store the dashes.

To have it display the dashes in you form or report then you need to format
the data.

 

[J_Goddard via AccessMonster.com]

Hi -

You can have the literal characters stored as part of the data by putting ;0
as the second part of the input mask, so your mask will be:

a\-aa\-a99\-aa\-99 ;0

Check the help for the inputmask property.

John

Maybe you have a misunderstanding of the use of mask.

If your mask is a\-aa\-a99\-aa\-99 and you type ugaCO1cfco01 it will disply
u-ga-CO1-cf-01 but it does not store the dashes.

To have it display the dashes in you form or report then you need to format
the data.

I have a column in a table that is text and has an input mask. When I enter
the data from the form to insert into the table it does not use the input

[quoted text clipped - 7 lines]

Thanks,
Currt

 

[Curt Hand]

It is displayed in the form with the dashes and the text box has the same
input mask but when it store the data into the table, the dashes are missing.

Curt

 

[Curt Hand]

I have the input mask properly done:
L\-LL\->LL0\-<LL\-LL\-00;0; table
L\-LL\->LL0\-<LL\-LL\-00;0; form

I do not know why it does not store the data in the correct format.

Thanks,
Curt

 

[Klatuu]

It does not store the mask characters unless you use the technique suggested
by J_Goddard; however, Why store them? It is only taking up extra space.
You should not be worried about how the data is stored, but how it is
presented. Use the Format property to display the value like you want it.

 

[Curt Hand]

Thanks,
Curt