Help!! Colours!! (1 Viewer)

[Tracy]

Can anyone please tell me how to set a colour of a text box on a report in visual basic.

I've tried Me!TextBox = RGB(255,0,0) but it just sets it to a weird number.

I think there is a format function but I can't find it.

Any help would save me!
Thanks

 

[Mile-O]

Me!TextBox.BackColor = RGB(255,0,0)

 

[Tracy]

Thanks, this works, but I wanted to change the font color.

Any ideas...husband?

 

[Tay]

Me!TextBox.ForeColor = RGB(255,0,0) should do it.

HTH

 

[Tracy]

Thank you Tay. Works a treat.

 

[Fornatian]

Rather than use the RGB function, you can use one of the VB constants such as vbRED as in:

Me!TextBox.BackColor = vbRed