'Ghost Text'

[kp123]

Can anyone guide me as to how I add text into a field that provides guidance such as 'estimate', which will disappear once populated.
I imagine that this is something you specify in the Property Sheet but cannot deduce where.



This may also come into play when I lock dowen specific cells - such as 'automatically populated' or 'for office use only'...

Thanks.

[hertfordkc]

Setting the visible property to False would make the label disappear.

[kp123]

Thanks herfordkc, but my interest is in placing instructional text in my existing cells.

In one secenario these should then disappear when you populate them with a response.
In the other scenario I am looking to write phrases such as 'Automatically generated - response not required' in locked down cells, e.g. those which generate an autonumber.

Hope this clarifies.
Thanks so much.

[hertfordkc]

Thanks herfordkc, but my interest is in placing instructional text in my existing cells.

In one secenario these should then disappear when you populate them with a response.
In the other scenario I am looking to write phrases such as 'Automatically generated - response not required' in locked down cells, e.g. those which generate an autonumber.
Why are you displaying fields that have no meaning to the user?
Hope this clarifies.
Thanks so much.

control? Normally the control is bound to a field in a query and anything placed in it updates a record.
There are a lot of things possible by using control events, so it may be possible, by e.g. using unbound text boxes, and event VBA to transfer input to a hidden bound control.

[kp123]

I will be sending out my forms to colleagues in other countries. I therefore want to be able to offer some basic guidance in a way more visible than just ToolTips within the text boxes themselves. This should disappear when text is typed in ...as, for example, occurs in many 'search' boxes.

[nicknameoscar]

You could still use a label. Just make the label not visible or make the label blank once data has been input by the user. You could put whatever message you want in whatever language you want when the form opens.

Edit: I realize now that I am just basically restating hertfordkc's ideas - sorry.

[kp123]

[QUOTE=nicknameoscar;92758]You could still use a label. Just make the label not visible or make the label blank once data has been input by the user... QUOTE]

...yes, yes - that's what I want to achieve!

I have been playing around with the 'default values' in the property sheet, although this seems a bit temperamental, so I'm not sure that it's correct.

I've looked at 'BeforeUpdates' which seems to be close to what I want but not 'IT'! It's also not Input Masks.

The description given for Prompts at http://msdn.microsoft.com/en-us/libr...4.aspx#prompts described my intension well but gives no explanation of how to go about setting this up!

Grrr...