Placeholding text in Textbox being saved to table - Access 2010

[sublevelmonkey]

Hi All,



Time to turn to the better minds again!

Instead of a label I'm using text in the format property of a textbox to identify fields on my form (using the following format: ;&"textstring"[red]).

This works fine and gets overwritten when I enter actual data and doesn't save the label/placeholder text into the underlying table if I don't overwrite it (which is not always necessary) BUT....

If I duplicate a record, when the duplicated record form appears any label/placeholder text that was not overwritten with actual data is now black and is being saved to the underlying table -somehow it's turned into 'live' information, rather than a placeholder. The format property in the property sheet has not changed and if I clear the textbox, the originally formatted label/placeholder returns (and is not saved down to the table).

This doesn't happen if I just move onto the next record in the form, only when I duplicate.

I'm guessing I should be adding some kind of update/refresh code but not sure what or where...

Hope that makes sense and someone can help.


Muchos gracias peeps!

[Rod]

That's novel. I've just researched the help for 2007 (I don't think it changed from 2003 in this instance) and wonder why you are not using @;"text"[red]

I agree ;&"text"[red] works but perhaps you ought to try the 'official' way first.

PS Sorry about the 2003 comment but that's what your profile says! Your title however says 2010.

[sublevelmonkey]

Thanks for that, I'll give it a go and see if it helps.

Can't remember where I picked up that way of formatting, making it all up as I go along makes my work something of a monster.

Just call me Frankenstein!

I'll also sort out my visible version.

UPDATE:

Changed to suggested format but, sadly, the problem persists...