Finding zero width fields

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

Guest

I made some mistakes in structuring my data to begin with, and so now I am
re-building a number of forms to work with new queries.

If possible, I don't want to rebuild the forms from scratch, as they are
quite involved. I have made copies, and told the copies of the forms to look
for data to the new query, and fixed all obvious cases where a field doesn't
know what to look for.

However, I must have put some zero-width fields in at some point. When I
try to open the form, Access asks me for parameter values for fields that I
don't see on the form. Is there any way to make those show up so that I can
get rid of them?

If I can't fix this, and have to rebuild the forms from scratch, can anyone
suggest a way that I could keep track of zero-width fields so that I don't
have to go through this aain?

Thanks from a struggling newbie.
 
I figured it out.

I made a copy, selected all and made all the fields have a long length. The
hypothesized zero-width fields did not exist.

My problem turned out to be subforms that I didn't realize were subforms,
and that need to be structured for the new data structure.

The moral of the story is definitely to get your data structure right at the
beginning.
 
Back
Top