Default Value?

[TallMan]

Hey Guys,

I have a form with a bunch of text boxes on it. I would like the "title/lablel" of the text box to appear within the actual box and then disapear when an associate enters information.

I have tried the default value in properties but have not had any luck. Has anyone done this before?

Thanks for any help you can provide!

Tall man.

 

[missinglinq]

Where YourTextboxName is the name of your textbox,

=[YourTextboxName_Label].[Caption]

entered in the Default Value Property of the textbox, in Design View, will place the control's label in the textbox.

To have it "disappear" when the user enters data you'll have to have the text hi-lited when the textbox is entered, either thru setting the the behavior to this in
Tools - Options or thru code.

 

[boblarson]

And you would need to use the form's Before Update event to remove those values if they are still there when the record is updated or you'll save that info to the tables.

 

[missinglinq]

Unless, of course, the OP wants the caption to remain in the textbox until data is entered. Records are not necessarily completed when they are first created.

 

[boblarson]

Unless, of course, the OP wants the caption to remain in the textbox until data is entered. Records are not necessarily completed when they are first created.

Ooh, can you imagine the havoc that would play with the data? You do a report and you would have to limit the display for everything so it wouldn't display those prompts as field values? I think if the record isn't complete then it should not store those prompts. Much easier to deal with that than to be trying to clean up a bunch of data for your queries and reports.

 

[missinglinq]

Oh, I agree, Bob! Better still would be to not do this at all! It really is ill-advised, I think, and could very well lead to all kinds of problems and extra work, as you've indicated.