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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

offerocker - 13 Sep 2007 06:38 GMT

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.

Reply to this Message

Bob Quintal - 13 Sep 2007 09:45 GMT

> ACCESS Table open, unable to close or modify telephone field. Had
> tried i/p mask of 0 due to "Unlisted" numbers appearing
[quoted text clipped - 5 lines]
> 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.

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

Andy Hull - 13 Sep 2007 10:08 GMT

Hi

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

> 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
[quoted text clipped - 4 lines]
> properly if the input mask did not match the field contents. I'm stuck!
> Thank you so much.

Reply to this Message