Varying text size within text box

[martinbanks]

Varying text box size dependent on each example

Is it possible to have the text size vary within a text box on a report?

I am trying to get

COMPANY - O/N - Del Date

to display as

COMPANY - O/N - Del Date

 

[rainman89]

Sadly, afaik you cannot do this

 

[martinbanks]

Sadly, afaik you cannot do this

what about achieving it indirectly; can I get a box to change it's size dependent on each result (eg ACF is much shorter than Topline Contract Furniture) and then another box that will change it's Left property to sit up next to it

Is that possible?

 

[rainman89]

Here is an msdn link on how to change the font using vba
http://msdn.microsoft.com/en-us/library/aa195892(office.11).aspx

 

[boblarson]

You can do this if you use a Rich Text box instead of a a normal text box. If you are using 2007 or above it comes with a native one. If you are 2003 or prior then Stephen Lebans has one.

 

[martinbanks]

You can do this if you use a Rich Text box instead of a a normal text box. If you are using 2007 or above it comes with a native one. If you are 2003 or prior then Stephen Lebans has one.

When I try to switch it to Rich Text it tells me the setting isn't valid on this property

I'm using Access 2007 btw

 

[boblarson]

When I try to switch it to Rich Text it tells me the setting isn't valid on this property

I'm using Access 2007 btw

The datatype needs to be memo in order to use Rich Text with it.