Number format such as 1-234567

  • Thread starter Thread starter Silvio
  • Start date Start date
S

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
 
Silvio said:
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
Click to expand...

Format property of "0-000000"

An InputMask would be required for the "see it as you type" part.
 
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 said:
Rick what you suggested will change my numbers to be 0-00000 and
that's not what I am loking for,
Click to expand...

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?
Click to expand...

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)
Click to expand...

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