Why do extra columns show up in a form?

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
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling in fields to a partially complete record in a table using a form 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Trouble Filtering a Sub Form With Combo Box Options 2
Show a subtable's value in Label 3
Multiple Columns on a Form 1
lookup columns 1
Form Lookup From Query - Display different from data in table 1
Columns in a form 2

Top