Greetings!
I have a access query that is based off a table, that I am using as a record source for a sub-form. I can set this up no problem, but my issue comes to play with the navigation.
For the life of me, I am unable to uncover how to:
1) Remove the empty white columns at the end of my dataset in the subform
2) have the sub form span the entire width of the parent form with no scroll-bar (right or left) -- the data being returned by the subform is small enough to fit.
I have attached a sample database so people can see what my issue is.
How can settings be changed to remedy this?Database1.zip
Now let me add, my issue comes into play when you open my main form, not the sub-form.