Programmatically Setting Split Form Datasheet Row Hight (1 Viewer)

JamesJoey

Registered User.
Local time
Today, 08:21
Joined
Dec 6, 2010
Messages
608
I'm using the following to set certain properties on a SplitForm datasheet:

Code:
Public Function DataSheetProperties(frm As Form)
   
    frm.DatasheetFontName = "Ebrima"
    frm.DatasheetFontHeight = 10
    frm.DatasheetFontWeight = 700
    frm.DataSheetRowHeight = ????

End Function

I'm getting: Error 2465 Application-defined or object-defined error) in procedure DataSheetProperties of Module DatabaseOperations

This works fine until I insert the line for the Rowheight.

Any ideas on how I can set the row height of the datasheet side of a split form?
 

isladogs

MVP / VIP
Local time
Today, 12:21
Joined
Jan 14, 2017
Messages
18,186
That's because there appears to be no such property as DatasheetRowHeight



Whether something else is available I don't know.
You could try creating that property yourself
Or you can just set the height manually & it will stick
 

Attachments

  • Capture.PNG
    Capture.PNG
    32.4 KB · Views: 147

JamesJoey

Registered User.
Local time
Today, 08:21
Joined
Dec 6, 2010
Messages
608
I couldn't find it in the Object Browser and thought I was simply missing something.

I'll just do it manually.

Thanks,
James
 

kevlray

Registered User.
Local time
Today, 05:21
Joined
Apr 5, 2010
Messages
1,046
FYI: I was curious about this. I see that there is a DatasheetFontHeight property. Which may in turn set the row height.
 

isladogs

MVP / VIP
Local time
Today, 12:21
Joined
Jan 14, 2017
Messages
18,186
The OP is already using that to set the font size.
What I believe he wants is to increase the height for each record so several rows of text can be shown at once in the same record …. if you see what i mean
 

Users who are viewing this thread

Top Bottom