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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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.
 
Back
Top