Change properties of a text box

[GraeagleBill]

I have a multipurpose report where I'd like to change the font size and textbox height under certain conditions. In changing the height of the textbox, I would also need to increase the height of the Detail section. Assuming this can be done, I also need to READ the current values so that I can restore them before exiting the report, UNLESS they automatically revert when the report closes.

I don't see the options I need when coding Me.MyTextBox.

Can I change these textbox properties in code?

Thanks,


Bill

[June7]

Maybe. Try code in the Detail section Format event. However, that event triggers only for PrintPreview.

[GraeagleBill]

June,
It turns out that even though the "auto-fill" list given by the VBA editor doesn't list all properties of a control, it is valid to code them.

         ' Since the printed posting will be viewed by many seniors, we're going to
         ' increase the size of the text to a size more appropriate.  The changes to
         ' the controls are not permanent, so it's not necessary to restore the design
         ' values.  All the values used here are in direct proportion to the overall
         ' design.  The desired "inch" values are entered in twips.
         Me.tbName.Height = 400
         Me.tbName.Width = 5340
         Me.tbName.FontSize = 18
         Me.Detail.Height = 500

Thanks,
Bill

[June7]

Which properties are not listing? I get all 4 that you show in the code.

[GraeagleBill]

With A2003, I don't get properties listed for:


Me.tbName.Height = 400 Me.tbName.Width = 5340 Me.tbName.FontSize = 18

I do get "Height" listed for Me.Detail.

Bill

[June7]

Oh, okay, been a while since I worked with 2003.