notation

[Jean-Paul]

Hi,
I designed a table with a "phone"-field..
I want it to look like 03/775.99.82

In notation I wrote: 00/000.00.00
When I go to the next field access changes this to: 00\/0.000.000

What am I doing wrong?
Should I make the field text or numeric
Should I use # instead of 0

I'm completely confused... any help is welcome

Thanks
JP

 

[John W. Vinson]

Hi,
I designed a table with a "phone"-field..
I want it to look like 03/775.99.82

In notation I wrote: 00/000.00.00
When I go to the next field access changes this to: 00\/0.000.000

What am I doing wrong?

Nothing. The \ is a "quote" character in input masks and formats, meaning that
the next character should be taken literally. This simply means that upi want
a literal virgule (/) character inserted.

Should I make the field text or numeric

Text, absolutely.

Should I use # instead of 0

# for Formats; 0 or 9 for Input Masks depending on whether you want the number
to be required or optional (I'd expect 0 in this case).

 

[Jean-Paul De Winter]

i'm confused...
What is the difference between notation and validation?

Thanks
JP