how to change the color of a text box in a form (1 Viewer)

[mana]

hello

i have a conitius form in ms access and in it i have a text box. i want to know if it possible to change the color of the text box to the color that i want ?
can you help me please?
thank you

 

[jdraw]

http://www.techonthenet.com/access/forms/change_bg.php

 

[bob fitz]

I believe it is possible to make such changes by changing the Background Color property of the text box either in design mode or using code at run time. However, I think the change would be visible in every record. Not sure if that is what you want.

Edit:
Sorry guys, didn't see the reply by jdraw.

 

[mana]

hello

but i want this just for a specific row but not for all of them.

 

[Minty]

Conditional formatting is the only way on a continuous form.

 

[mana]

hello

can you guide me more what i can do here?
what should i write in conditional formattion?
i want just to change the background of the focused textbox just in a row not in all of the rows
thank you

 

[Minty]

Sigh - If only there was a way to look things up on some massive global store of information that took mere milliseconds and didn't involve a lot of effort...

Oh wait ! Apparently this new thing called Google can do some of this magic...

http://www.utteraccess.com/wiki/index.php/Continuous_Forms:_Highlight_Current_Row
Or More complicated http://access.mvps.org/access/forms/frm0024.htm

 

[mana]

hello

i want to say if the activecontrol is true then the color of the active control will be red but i don't know how to say it
can you help me please?

If Screen.ActiveControl = True Then

what to write here?

End If

 

[Minty]

http://lmgtfy.com/?q=microsoft-access-highlight-the-current-active-form-control

The Allen Browne method is very flexible. However it won't work on continuous forms as far as I am aware.

 

[BitsOfBytes]

Create macro for on focus event of that box. Use 'set property' to change back color? Opposite on loss of focus?