Need to remove data in table due to input mask; cannot close.

[Guest]

ACCESS Table open, unable to close or modify telephone field. Had tried i/p
mask of 0 due to "Unlisted" numbers appearing right-justified when doing a
report. I sure thought I changed it back to a NO MASK prior saving the table.
Now, table is open and I am unable to do anything with that field, even
deleting the content, to satisfy the mask problem. Hands seems to be tied in
'catch 22'; I would have thought (!!??) that the table would not have saved
properly if the input mask did not match the field contents. I'm stuck!
Thank you so much.

 

[Bob Quintal]

ACCESS Table open, unable to close or modify telephone field. Had
tried i/p mask of 0 due to "Unlisted" numbers appearing
right-justified when doing a report. I sure thought I changed it
back to a NO MASK prior saving the table. Now, table is open and I
am unable to do anything with that field, even deleting the
content, to satisfy the mask problem. Hands seems to be tied in
'catch 22'; I would have thought (!!??) that the table would not
have saved properly if the input mask did not match the field
contents. I'm stuck! Thank you so much.

I think that you have made the all-too-common error of assuming that a
telephone number belongs in a number type field. Change the field type
to text, length 14 (to handle international numbers, Remove the input
mask, set properties to allow nulls and allow zero-length strings.

Once done fix any data with 0a and you should be ok.

 

[Guest]

Hi

An input mask of 0 means any single digit... can you not enter a single digit?