Font control with an unbounded text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to modify some font properties on an unbound text box with VBA, but
the properties don't sems to be available like they are on a bounded text box.

How do I go about this?

TIA for all your help.

Lee
 
Not true, the properties are the same for both except that a bound control
has a control source.
Where and how are you trying to set the font?
 
I'm using the "on Format" event of the Group Footer section.

Using the syntax "Me.HowMany", where HowMany is the name of the unbounded
text box, does not show any properties for Font.....

It does show properties for OldValue and ItemData.

Can you send me in the right direction. I simply want to set the Font
Properties of Name, Weight, Size and Italic


Thanks,
Lee
 
Is this in a report or a form? I tried adding an unbound text box to a
report in a group footer and all the font options showed up.
 
It is in a report. In design mode, I can see all the properties, but when in
the VBA editor, they don't come up.

BTW, it's not really an unbounded text box, in the true sense of the word.
It's a text box that uses another text box for a running sum. It's not
bounded to a DB field, but does have a control source.

Any ideas?

Thanks,
Lee
 
I'm using the "on Format" event of the Group Footer section.

Using the syntax "Me.HowMany", where HowMany is the name of the unbounded
text box, does not show any properties for Font.....

It does show properties for OldValue and ItemData.

Can you send me in the right direction. I simply want to set the Font
Properties of Name, Weight, Size and Italic

Thanks,
Lee
Click to expand...

I guess this is on a report.

Access Intellisense doesn't always list all the available properties
in the drop-down as you type, but you can code them anyway.
For instance, if you add a page break control to a section, the
Visible property will not show in the drop-down list of it's
properties, but you can code it in the format event:
Me!PageBreakName.Visible = False

Code the Group Header Format event:
' Take your pick of the ones you want.
Me![ControlName].FontName = "Times New Roman"
Me![ControlName].FontSize = 14
Me![ControlName].FontBold = True
Me![ControlName].FontItalic = True
 
Thank you, Fred. That absolutely did the trick!

Much Appreciated.

Lee

fredg said:
I'm using the "on Format" event of the Group Footer section.

Using the syntax "Me.HowMany", where HowMany is the name of the unbounded
text box, does not show any properties for Font.....

It does show properties for OldValue and ItemData.

Can you send me in the right direction. I simply want to set the Font
Properties of Name, Weight, Size and Italic

Thanks,
Lee
Click to expand...

I guess this is on a report.

Access Intellisense doesn't always list all the available properties
in the drop-down as you type, but you can code them anyway.
For instance, if you add a page break control to a section, the
Visible property will not show in the drop-down list of it's
properties, but you can code it in the format event:
Me!PageBreakName.Visible = False

Code the Group Header Format event:
' Take your pick of the ones you want.
Me![ControlName].FontName = "Times New Roman"
Me![ControlName].FontSize = 14
Me![ControlName].FontBold = True
Me![ControlName].FontItalic = True
Click to expand...
 
Please post the code you're trying to use. All properties are exposed
independent of wether or not the text box is bound to a data source. To
access the properties btw, try

Me.[controlname].[propertyname]
 
Back
Top