How do I change a field size?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a number of tables which have a text field of the same name. It is
used to hold a record reference number and links the tables together in
queries. Currently it is 15 characters long but I want to increase it to 20.
If I try and do it in table design I get a message that says it is used to
link tables in a relationship and I must delete the relationship first. Is
there anyway I can do this rather than opening dozens of queries, deleting
the relationship, change the field size then open all the queries again to
re-create the relationship? I tried opening the Relationship window but
there aren't any shown there as I only create the relationship at the query.
Thanks
Tony
 
Are you sure there are no relationships? Make sure you click on Show All
under the Relationship window.

Joins you've created only in queries will not cause that message to be
generated.

Have you perhaps used the field as a Lookup field?
 
Back
Top