VBA Text (1 Viewer)

K

kitty77

Registered User.

Local time

Yesterday, 23:07

Joined

May 27, 2019

Messages

710

• Nov 10, 2019

• #1

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

I’m here to help

Staff member

Local time

Yesterday, 20:07

Joined

Oct 29, 2018

Messages

21,453

• Nov 10, 2019

• #2

Hi. Where is the text going to be displayed?

 

K

kitty77

Registered User.

Local time

Yesterday, 23:07

Joined

May 27, 2019

Messages

710

• Nov 10, 2019

• #3

On a report

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 20:07

Joined

Oct 29, 2018

Messages

21,453

• Nov 10, 2019

• #4

kitty77 said:

On a report

Click to expand...

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

 

K

kitty77

Registered User.

Local time

Yesterday, 23:07

Joined

May 27, 2019

Messages

710

• Nov 10, 2019

• #5

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

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 20:07

Joined

Oct 29, 2018

Messages

21,453

• Nov 10, 2019

• #6

kitty77 said:

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

Click to expand...

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

 

K

kitty77

Registered User.

Local time

Yesterday, 23:07

Joined

May 27, 2019

Messages

710

• Nov 10, 2019

• #7

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

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

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 20:07

Joined

Oct 29, 2018

Messages

21,453

• Nov 10, 2019

• #8

kitty77 said:

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

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

Click to expand...

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


PS. It should look something like this:

 

Attachments

• 
  rtf.png

  17.3 KB · Views: 166

K

kitty77

Registered User.

Local time

Yesterday, 23:07

Joined

May 27, 2019

Messages

710

• Nov 10, 2019

• #9

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?

 

K

kitty77

Registered User.

Local time

Yesterday, 23:07

Joined

May 27, 2019

Messages

710

• Nov 10, 2019

• #10

Looks like it only works on unbound fields?

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 20:07

Joined

Oct 29, 2018

Messages

21,453

• Nov 10, 2019

• #11

kitty77 said:

Looks like it only works on unbound fields?

Click to expand...

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.

 

K

kitty77

Registered User.

Local time

Yesterday, 23:07

Joined

May 27, 2019

Messages

710

• Nov 10, 2019

• #12

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

 

Gasman

Enthusiastic Amateur

Local time

Today, 04:07

Joined

Sep 21, 2011

Messages

14,231

• Nov 10, 2019

• #13

kitty77 said:

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

Click to expand...

Only applies to Memo types I believe?