Simple Question - Combo Box Default Text

[sayitgreen]

Hello,

This is my first post here. I am relatively new to Access and have to admit I have been finding it a little quirky and have been facing difficulties finding simple information in Microsoft's help files...

Right now I am trying to have my combo boxes in a form display simple user prompts such as "Select a product type..." I would like these prompts to disappear once the user clicks on the combo box to make a selectrion.

How do I go about doing this? I'd rather not add the prompt text as a value in the combo box list (don't want the prompt text showing up in my DB), but I cannot find another way to do it!

I feel like this should be something simple but I haven't been able to figure it out for days.

Please help!

Thanks,

Andy

[Jamy]

Add an event procedure with the event on got focus.

In VBA type this:
me.[field name] = ""

It's that simple. However this means that everytime the field is selected it clears. You can solve this by changing the code to:
If me.[field name] = "your default text" then
me.[field name] = ""
End If

[jbarrum]

Hello SayIt

If I am understanding you correctly you want a drop down on the form with text next to the drop down that says "Select a product Type". You want this message to dissapear after the user makes the selections because you do not want this message stored in your database. Or is it the users selection(product type) that you do not want stored.

1) If it is the message then you will be fine. Text on a form is not stored in the DB.
2) If it is the selection chosen then the question would be one of two.
a) Do you want the selection made stored, or
b) Do you want a record on the form selected based on the value chosen from the drop down?

[sayitgreen]

Jamy and jbarrum,

Thank you so much for your thoughts! Jamy it looks like you are on the right track with what I am trying to do. I will give your suggestion a try and let you know if it works.

Thank you!!