Field list incomplete

[KyleS]

Hello again,
In my query design, when I bring in either of two of my tables, they are both missing the last field on the field list. It doesn't matter which field is last, it won't show up.

I have gone into the table design and moved the order of the fields around and the last one always dissapears.

If anyone knows why thins is happening, I would appreciate any help, so much as a hint would be imensely useful.

Thanks in advance,
Kyle

 

[MichaelRed]

This occurs after you have scrolled the field list ListBox?



MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[KyleS]

Yes, the first table has 31 fields in it. But for some reason the last won't show up. I know it has nothing to do with the number of fields (I've tried adjusting that with no advantageous results) it just will not show the last field in the table. Regardless of it's properties or data there-in. If you would like I could e-mail you a pic of what this looks like...

 

[MichaelRed]

A "Pic" wont do me any good. If you send a mini ver of the db, I'll look at it. Just the table (with a few records) and the query, along with the form or report where the query is used.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over