Extra columns (blank) on datasheet

[Gasman]

Hi everyone,

I have a subform in datasheet view that for some reason shows 10 extra blank columns on it, making the main form stupidly wide.:banghead:

How can I identify what is causing it please?
SQL is

SELECT Emails.*, Lookups.Data
FROM Emails LEFT JOIN Lookups ON Emails.CaseWorker = Lookups.ID
ORDER BY Emails.ID;

and the screen looks like attached.

TIA

 

[JHB]

Have you tried to create a new subform?
Show the subform in design view, or even better post a sample database.

 

[CJ_London]

the blank columns to the right are the standard behaviour for a datasheet. You have simply scrolled too far. It is one of the limitations of a datasheet view - it will keep scrolling until there is only the last column visible. The same effect can be seen with the vertical scroll bar, it will keep scrolling until only the last record is visible.

your options are
1. You can turn off the gridlines in File>Options>Datasheet but you will still get space to the right, and of course your controls will not be defined by a vertical line

2. resize columns and/or remove columns not required so the datasheet fits within the subform without horizontal scrolling, then disable the horizontal scrollbar.

3. use a continuous/multi item form.

 

[Gasman]

JHB,

No, but I will try CJ_London's options first, just due to the code behind the subform.
The subform is trying to emulate a split form, as when I created this database it was on 2003 version.

Thank you both for the replies. This forum is a life saver for people like me.

Have you tried to create a new subform?
Show the subform in design view, or even better post a sample database.