Subform Formatting

HappyBunny

Registered User.
Local time
Today, 11:42
Joined
Jun 6, 2008
Messages
22
I have a datasheet subform that shows a different number of raws/records for each record in the main form.
HOW DO I FORMAT THE EMPTY SPACE LEFT WHEN THERE'S ONLY A FEW RAWS SHOWING. BACKGROUND COLOR AND SUCH.

<Also, if anyone knows why i can't get a blank record for data entry on that form, please let me know. i think it has something to do with it having no primary key common with the main form. data addition is set to yes. >
 
There are a number of properties you can set for your datasheets. Background color is one of them.

Private Sub Form_Open(Cancel As Integer)
Me.DatasheetBackColor = vbRed
End Sub

If you set the background color to that of the main form and the subform has no border, the subform will blend into the background of the main form.
 

Users who are viewing this thread

Back
Top Bottom