Why do extra columns show up in a form?

  • Thread starter Thread starter Webtechie
  • Start date Start date
W

Webtechie

Hello,

I've created a table to show my processed results. I've placed that table
on the form as a subform. Works great.

However, if you scroll to the right, you see columns past my last table
column. They have no header and you can't click on them. But why are they
showing?

I looked at the table in the datasheet and I see the same thing. After the
last column, there are still more columns. They aren't filled and you can't
click on them.

Is this just an anomaly of Microsoft Access to mess with new developers?
Can we just show the columns which pertain the table and no more?

Thanks,

Tony
 
No, Access doesn't mess with new developers like that: it's far more
devious. <g>

Are you certain that the additional columns aren't actually in the table?

Try creating a query with exactly the fields you need, and using that query
as the RecordSource.
 
Back
Top