How to control attributes of form in Datasheet view

I have a form I want to display as a sub form on a parent.  Things like font size, column widths and row heights seem to have minds of their own!  How do I control those attributes of the sub form in datasheet view.  Also, is there any way to not show the column headers?
LVL 1
wsturdevAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jefftwilleyCommented:
There is a menu bar that controls datasheet formatting. Depending on your version of access, it can be found under view/toolbars, or under the Format menu option.
As far as I know, there is no way to rid yourself of the datasheet column headings. You can fake it by using continuous forms modified to appear like a datasheet view, but that doesn't sound like what you're after.
J
0
Jeffrey CoachmanMIS LiasonCommented:
wsturdev,

You can control the Fontsize and Row Height through VBA as well.
Use code similar to this:
Private Sub Form_Open(Cancel As Integer)
   Me.DatasheetFontHeight = 14
   Me.RowHeight = 225
End sub

Hope this helps as well

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wiswalldCommented:
As far as the column headers I don't believe you can hide as jeffwiley said. If you open the subform in a new window and in design view you should be able to set the font properties for the cells. Also if you make changes there to row height and width it should reflect opn the main form.
0
UTSAOITCommented:
boag2000 got me on the right track.  I'm using 2007 and found the following steps took care of the issue for me.  After opening the subform in design view, I opened the Property Sheet.  Under the Event tab, I created an Event Procedure, selecting the Code Builder option.  On the left was a list of Properties in which I found what I was looking for, DatasheetFontName, DatasheetFontHeight, RowHeight, etc.  

The part I don't understand is the blank Sub that is created.  Maybe my approach isn't the most efficient, but I was able to set the font like I wanted.  Hope this helps.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.