Hide text on focus in continuous form (1 Viewer)

[Kayleigh]

Hi
I have a continuous form with alternate row colours (white and grey).
I am looking to hide the text in one column when it has focus - usually I would change the text colour to white using conditional formatting. However it would not be transparent in the grey rows.
Any ideas of how this could work?

 

[Josef P.]

Just an idea:
Don't hide the text but put the focus into an unbound textbox that is exactly behind the one textbox.

 

[Kayleigh]

Interesting. Will give it a try

 

[isladogs]

As an alternative, look at this article

Click Me And I Disappear!

In older versions of Access up to A2010, you could only disable, lock or hide controls if they did not have the focus. In recent years, that limitation was changed . . . with some interesting side effects!

www.isladogs.co.uk

Or just use this code on the Click event to hide all the text in each record of the field
Me.ControlName.Forecolor=Me.ControlName.Backcolor
However, you won't then be able to edit the field!