VBA Text

[kitty77]

Is it possible to change the font, bold, etc... in vba?

[Field1] = "Apple" & vbCrLf & "Blue" & vbCrLf & "Red"

How can I make "Blue" bold or Italic only?

Thanks...

 

[theDBguy]

Hi. Where is the text going to be displayed?

 

[kitty77]

On a report

 

[theDBguy]

On a report

Have you tried setting the Text Format to Rich Text and then use HTML tags in your VBA?

 

[kitty77]

Where do I set it to rich? Can you give me an example?

 

[theDBguy]

Where do I set it to rich? Can you give me an example?

In the design view of the report, select the textbox and then look in the properties panel for the text format property.

 

[kitty77]

When I change the settings to rich, I get an error.

The setting you entered isn't valid for the property.

 

[theDBguy]

When I change the settings to rich, I get an error.

The setting you entered isn't valid for the property.

Hi. Can you post a screenshot of what you're changing? Thanks.


PS. It should look something like this:

 

[kitty77]

Yes, it is the same as yours. Same error on a report or form.
Also, tried it on different text fields. I get the same error?

 

[kitty77]

Looks like it only works on unbound fields?

 

[theDBguy]

Looks like it only works on unbound fields?

Okay, if it's for a bound field, you'll have to go to the table design first and change the text format for the field to Rich Text as well.

 

[kitty77]

I don't see anything in the table design where you change text format?

 

[Gasman]

I don't see anything in the table design where you change text format?

Only applies to Memo types I believe?