R
RJK
Hello all you guru's
I'm working my way through "Access 2000 for Dummies," having worked, on and
off, in DOS databases for years, and have been away from them for years !
....and I foolishly thought that my previous grounding in database concepts
and design would be of use, ...well I know they will be if I can get past
some of the stupid GUI features that supposedly make things easier in Access
!
....anyheeeew...I've been fighting with a simple input mask, for a text
field, for 'phone no's FOR OVER AN HOUR...more like TWO !!!!!
....I keep referring to the Access Help screen for input mask syntax, (which
seems to have lots of information missing as does the above mentioned book),
and changing the mask, then nipping out to the table to put in a telephone
no. into the field, and I get unpredictable left to right justification (I
tried putting ! in the Design View / Format slot for the field), I've even
ended up with spaces actually stored in a field, in front of the telephone
no. as though the field contents are being padded, at the front of the
entered data, with spaces !!!
I've even tried makeing changes and then closing an reopening the table, and
even closing and restarting the Access 2000 program, in case stored changes
aren't being refreshed somewhere.
.....enough rambling...
e.g.
!\0000" "000000999 a four digit prefix, a space, six more required digits
and three optional digits.
Entering 1234123456 into this field, (using the table itself for data
entry), results in only the 123 appearing leftmost / before the space, as
though one of the first mask zero's isn't working ! And because I didn't
enter an extra 3 no's for the 999 part of the mask, this seems to cause
three spaces to be stored at the front of the 123123456 entered data !
any pointers muchly appreciated
regards, Richard
I'm working my way through "Access 2000 for Dummies," having worked, on and
off, in DOS databases for years, and have been away from them for years !
....and I foolishly thought that my previous grounding in database concepts
and design would be of use, ...well I know they will be if I can get past
some of the stupid GUI features that supposedly make things easier in Access
!
....anyheeeew...I've been fighting with a simple input mask, for a text
field, for 'phone no's FOR OVER AN HOUR...more like TWO !!!!!
....I keep referring to the Access Help screen for input mask syntax, (which
seems to have lots of information missing as does the above mentioned book),
and changing the mask, then nipping out to the table to put in a telephone
no. into the field, and I get unpredictable left to right justification (I
tried putting ! in the Design View / Format slot for the field), I've even
ended up with spaces actually stored in a field, in front of the telephone
no. as though the field contents are being padded, at the front of the
entered data, with spaces !!!
I've even tried makeing changes and then closing an reopening the table, and
even closing and restarting the Access 2000 program, in case stored changes
aren't being refreshed somewhere.
.....enough rambling...
e.g.
!\0000" "000000999 a four digit prefix, a space, six more required digits
and three optional digits.
Entering 1234123456 into this field, (using the table itself for data
entry), results in only the 123 appearing leftmost / before the space, as
though one of the first mask zero's isn't working ! And because I didn't
enter an extra 3 no's for the 999 part of the mask, this seems to cause
three spaces to be stored at the front of the 123123456 entered data !
any pointers muchly appreciated
regards, Richard