Number format such as 1-234567

[Silvio]

Hi, how can I have a field to display the number such as 1234567 as 1-234567.
It should show with this format as you type, meaning that as soon you type 1
it should display 1- in the box. This should be a format issue only since the
actual number in the table will be saved as 1234567 and it will be a Long
Integer.

Thanks.
Silvio

 

[Rick Brandt]

Hi, how can I have a field to display the number such as 1234567 as
1-234567. It should show with this format as you type, meaning that
as soon you type 1 it should display 1- in the box. This should be a
format issue only since the actual number in the table will be saved
as 1234567 and it will be a Long Integer.

Thanks.
Silvio

Format property of "0-000000"

An InputMask would be required for the "see it as you type" part.

 

[Silvio]

Rick what you suggested will change my numbers to be 0-00000 and that's not
what I am loking for, also the format should be a the form or table level? I
have tried #-##### however the system changes the last digit to read this way
(e.g. 123456-7)

 

[Silvio]

I got it. In the form field property InputMask I entered #\-######

Thanks anyway.

 

[Rick Brandt]

Rick what you suggested will change my numbers to be 0-00000 and
that's not what I am loking for,

No it will not. If your field is Text you would have to configure the
InputMask to store the dash, but you can also configure it NOT to do that.
If your field is numeric then it would not be possible to store the dash
except at the start of a negative value.

also the format should be a the form
or table level?

Wherever you will be looking at it and want to see that format. Format
properties do not propagate.

I have tried #-##### however the system changes the
last digit to read this way (e.g. 123456-7)

You tried that where? As a format property it makes no sense.