Spit Form Datasheet Font Size Not Changing (1 Viewer)

[JamesJoey]

I'm using the following in the onload of a split form:

Me.DatasheetFontHeight = 12

Problem is the font size doesn't change.

I even change the FontHeight to 18 and it remained the same size.

Any ideas?
James

 

[sneuberg]

I tried that too. Apparent it's not that simple. I tried the code in this site and that works.

 

[JamesJoey]

Not sure if I'll need all the code, especially the on timer event.
I'll try it and see what happens.

Thanks much,
James

 

[speakers_86]

I've got a sample here that duplicates the split form while only using a subform. I'll be posting an update soon to fix a couple things.

 

[arnelgp]

you can use the Open event of the the form to set it.

 

[sneuberg]

you can use the Open event of the the form to set it.

That works. I would have never thought to try that as the Open event fires before the Load event. It doesn't work in the Load event but you can do it in a Timer event started by the load event as outline in this Web Page where the author states, "Routine placement of code in form's load event won't do as the datasheet portion is not yet exposed at this stage."

Do you happen to know why this works in the Open event?

 

[arnelgp]

i don't know neither. i just make a quick test.

 

[JamesJoey]

Yes, it works fine on the on open.

I've also considered using a continuous subform with a main form.
I want to simulate the splir form with the datasheet on the left and the single form on the right.

This is my DVD movie database with a lookup table for the movie genres. Currently I'm filtering the movies using a combo box populated with the lookup table.

Ideally though, I'd like to have a treeview control to have my movie genres in the main nodes and the movie titles assigned to each genre below.
But I believe that is way out of my league. I wouldn't even know where to start.

 

[sneuberg]

Ideally though, I'd like to have a treeview control to have my movie genres in the main nodes and the movie titles assigned to each genre below.
But I believe that is way out of my league. I wouldn't even know where to start.

This video looks like a good place to start.

 

[JamesJoey]

I'll check it out.

Thanks,
James