How to change field properties in a table?

  • Thread starter Thread starter Amit
  • Start date Start date
A

Amit

Hi,

I have some fields in a table that are:
-required (yes)
-allow zero length (yes)

I'd like to change it to allow zero length (no).

When I try to do that, I get a warning from Access:

"Data integrity rules have been changed, existing data may
not be valid for new rules. Do you want the existing data
to be tested with the new rules?"

When I select "Yes", I get the message "Errors were
encountered, properties were not updated."

I'm not sure what's causing this error. I've checked the
table, and there is no record with zero-length data for
that field.

Should I just go ahead and change the properties wihout
testing the existing data as long as I'm sure that all the
existing data for that field is not zero-length? Am I
missing something? Is there another way around this?

This table is linked to other tables in the database.

Thanks for any help.

-amit
 
You can't change many properties of the >linking< table. You have to change
them in the >linked to< table. Is that the problem?

HTH,
TC
 
Back
Top