text field with input mask

[Blinda]

Hi all,

I have a text field with field size of 6, input mask of &99.99. So it is ok
for me to data entry data like E55.66, or 777.88.

Now I need enter E123.45. If I change it to field size 7 and input mask of
C999.99, I can enter E123.45, but all of my old data will be wrong. What
should I do to keep all the old data right and also be able to enter my now
data?

Thanks,

Blinda

 

[FedBrad]

Hi all,

I have a text field with field size of 6, input mask of &99.99. So it is ok
for me to data entry data like E55.66, or 777.88.

Now I need enter E123.45. If I change it to field size 7 and input mask of
C999.99, I can enter E123.45, but all of my old data will be wrong. What
should I do to keep all the old data right and also be able to enter my now
data?

Thanks,

Blinda

 

[FedBrad]

Your input mask needs to be adjusted. To clarify, here's a little about the
characters used in your masks...

The positions where you are using a '9' will only accommodate a digit or a
space. But, your earlier data had an alpha character in the position you
have now defined as a digit or space only. Thus, the old data no longer
meets the criteria of the new input mask.

Depending on the number of variations of where in your data the "E" might
appear, you'll have to craft your input mask accodingly.

 

[John Nurick]

Hi Blinda,

Instead of using an input mask, use a validation rule. It's not clear
just what characters are acceptable, but something like this may do the
job:

IS NULL OR LIKE "E###.##" OR LIKE "[0-9E]##.##"

If the first character can be a letter other than E, try

IS NULL OR LIKE "[A-Z]###.##" OR LIKE "[0-9A-Z]##.##"

 

[Blinda]

Thanks, John. It works well for the new data entry. but all the old data are
getting wrong. E55.66, or 777.88 will be E5566, 77788.

Hi Blinda,

Instead of using an input mask, use a validation rule. It's not clear
just what characters are acceptable, but something like this may do the
job:

IS NULL OR LIKE "E###.##" OR LIKE "[0-9E]##.##"

If the first character can be a letter other than E, try

IS NULL OR LIKE "[A-Z]###.##" OR LIKE "[0-9A-Z]##.##"

Hi all,

I have a text field with field size of 6, input mask of &99.99. So it is ok
for me to data entry data like E55.66, or 777.88.

Now I need enter E123.45. If I change it to field size 7 and input mask of
C999.99, I can enter E123.45, but all of my old data will be wrong. What
should I do to keep all the old data right and also be able to enter my now
data?

Thanks,

Blinda

 

[Blinda]

Thanks. I tried C&99.99, still have the same problem for the old data. do you
know how can I add a space at the beginning of my old data?

If I could set my field size to 7 and add a space to all of my old data, it
should be ok for me to use input mask of C&99.99. Please help.

 

[FedBrad]

Blinda,

Are you typing the decimal point into the text box when you are entering the
data? If not (or, if you don't want to), then the following input mask
accommodates both entries you included earlier:

CC99\.99! or you could also use CCCC\.99!

The back slant ( '\' ) forces the decimal to be inserted after the first two
digits. And, the exclamation point ( '!' ) forces whatever is typed to fill
into the mask from right to left.

If are typing the decimal point (and really want to), then the following
mask works for that:

CCCCC99!

Thanks, John. It works well for the new data entry. but all the old data are
getting wrong. E55.66, or 777.88 will be E5566, 77788.

Hi Blinda,

Instead of using an input mask, use a validation rule. It's not clear
just what characters are acceptable, but something like this may do the
job:

IS NULL OR LIKE "E###.##" OR LIKE "[0-9E]##.##"

If the first character can be a letter other than E, try

IS NULL OR LIKE "[A-Z]###.##" OR LIKE "[0-9A-Z]##.##"

Hi all,

I have a text field with field size of 6, input mask of &99.99. So it is ok
for me to data entry data like E55.66, or 777.88.

Now I need enter E123.45. If I change it to field size 7 and input mask of
C999.99, I can enter E123.45, but all of my old data will be wrong. What
should I do to keep all the old data right and also be able to enter my now
data?

Thanks,

Blinda

 

[Blinda]

Thanks. It works very well. But I have new problem here: some of my new data
have only one or no digit after the decimal point.

Blinda,

Are you typing the decimal point into the text box when you are entering the
data? If not (or, if you don't want to), then the following input mask
accommodates both entries you included earlier:

CC99\.99! or you could also use CCCC\.99!

The back slant ( '\' ) forces the decimal to be inserted after the first two
digits. And, the exclamation point ( '!' ) forces whatever is typed to fill
into the mask from right to left.

If are typing the decimal point (and really want to), then the following
mask works for that:

CCCCC99!

Thanks, John. It works well for the new data entry. but all the old data are
getting wrong. E55.66, or 777.88 will be E5566, 77788.

Hi Blinda,

Instead of using an input mask, use a validation rule. It's not clear
just what characters are acceptable, but something like this may do the
job:

IS NULL OR LIKE "E###.##" OR LIKE "[0-9E]##.##"

If the first character can be a letter other than E, try

IS NULL OR LIKE "[A-Z]###.##" OR LIKE "[0-9A-Z]##.##"

On Wed, 21 Mar 2007 13:20:05 -0700, Blinda

Hi all,

I have a text field with field size of 6, input mask of &99.99. So it is ok
for me to data entry data like E55.66, or 777.88.

Now I need enter E123.45. If I change it to field size 7 and input mask of
C999.99, I can enter E123.45, but all of my old data will be wrong. What
should I do to keep all the old data right and also be able to enter my now
data?

Thanks,

Blinda

 

[Blinda]

I did not enter the decimal point. Could you please help how can I enter data
like 412 or 412.3? Thanks. Blinda

Blinda,

Are you typing the decimal point into the text box when you are entering the
data? If not (or, if you don't want to), then the following input mask
accommodates both entries you included earlier:

CC99\.99! or you could also use CCCC\.99!

The back slant ( '\' ) forces the decimal to be inserted after the first two
digits. And, the exclamation point ( '!' ) forces whatever is typed to fill
into the mask from right to left.

If are typing the decimal point (and really want to), then the following
mask works for that:

CCCCC99!

Thanks, John. It works well for the new data entry. but all the old data are
getting wrong. E55.66, or 777.88 will be E5566, 77788.

Hi Blinda,

Instead of using an input mask, use a validation rule. It's not clear
just what characters are acceptable, but something like this may do the
job:

IS NULL OR LIKE "E###.##" OR LIKE "[0-9E]##.##"

If the first character can be a letter other than E, try

IS NULL OR LIKE "[A-Z]###.##" OR LIKE "[0-9A-Z]##.##"

On Wed, 21 Mar 2007 13:20:05 -0700, Blinda

Hi all,

I have a text field with field size of 6, input mask of &99.99. So it is ok
for me to data entry data like E55.66, or 777.88.

Now I need enter E123.45. If I change it to field size 7 and input mask of
C999.99, I can enter E123.45, but all of my old data will be wrong. What
should I do to keep all the old data right and also be able to enter my now
data?

Thanks,

Blinda

 

[FedBrad]

Sorry, I assumed you would always have the two decimal places. Since not,
then typing in the decimal point manually becomes a given (because it may, or
may not, be necessary). Therefore, changing the input mask to CCCCCCC! will
handle any of the combinations you have mentioned.

But remember... now you will have to type in the decimal point as well -
because its position may change, or not be present at all.

I did not enter the decimal point. Could you please help how can I enter data
like 412 or 412.3? Thanks. Blinda

Blinda,

Are you typing the decimal point into the text box when you are entering the
data? If not (or, if you don't want to), then the following input mask
accommodates both entries you included earlier:

CC99\.99! or you could also use CCCC\.99!

The back slant ( '\' ) forces the decimal to be inserted after the first two
digits. And, the exclamation point ( '!' ) forces whatever is typed to fill
into the mask from right to left.

If are typing the decimal point (and really want to), then the following
mask works for that:

CCCCC99!

Thanks, John. It works well for the new data entry. but all the old data are
getting wrong. E55.66, or 777.88 will be E5566, 77788.

:

Hi Blinda,

Instead of using an input mask, use a validation rule. It's not clear
just what characters are acceptable, but something like this may do the
job:

IS NULL OR LIKE "E###.##" OR LIKE "[0-9E]##.##"

If the first character can be a letter other than E, try

IS NULL OR LIKE "[A-Z]###.##" OR LIKE "[0-9A-Z]##.##"

On Wed, 21 Mar 2007 13:20:05 -0700, Blinda

Hi all,

I have a text field with field size of 6, input mask of &99.99. So it is ok
for me to data entry data like E55.66, or 777.88.

Now I need enter E123.45. If I change it to field size 7 and input mask of
C999.99, I can enter E123.45, but all of my old data will be wrong. What
should I do to keep all the old data right and also be able to enter my now
data?

Thanks,

Blinda