Go to the Relationships Window and make sure that All Relationships is
selected. It's also possible that ad hoc relationships in queries,
form-subforms, and reports-subreports can cause this problem.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Steve Stad" wrote:

I was trying to update field size in table design. I get a message saying
'You can't change the data type or field, it is part of one or more
relationships. If you want to change the data type of this field, first
delete its relationship in the Relationships window.
I have deleted the relationship and I still get this message when trying to
update the field size.