Setting report orientation using VBA

[sneuberg]

Also, I want to allow the user to select the font and size.
Cant I do this by allowing the Font controls to be shown, when I build a Runtime version?

I don't know what you mean by Font controls. You could provide this functionality by putting combo boxes on the form with the fonts and sizes and then assign them to the verse text box in the report during the report load event. So let's say the combo for fonts is named cboFont. Then in the report load event you would have.

Me.Text1.FontName = [Forms]![Frm_Verses_mstr]!cboFont

similar to the way you are doing to the Text1 sizes.

This is probably work you would rather avoid and maybe there is some other way of letting the user modify the fonts of a report. I suggest starting a new thread on that topic so that it attracts the attention of the other forum members.

 

[jdraw]

Does anyone have an example data base that demos the setting of printer properties via vba? If so, please post.

 

[sneuberg]

Right! Just the issue of why the reset filter not working.

Ok now I see what you mean. Apparently the textboxes with the control sources from the combo box can't be set to null. For the way things are now you can fix this just by not setting any textboxes to null or in cmdReset_Click of the Frm_Verses_mstr form change the line:

 Case acTextBox, acComboBox

to

 Case  acComboBox