force a combo box to be blank (show no data)

[KennyUK]

Hi,

For various reasons, I need a way (in code if possible) to force a combo box to be displayed on a form blank insted of showing the first item in its list as it is now.

If anyone can help me with the correct syntax or command I would very grateful.

Kind regards,

Kenny

 

[nickjar2]

Kenny, I think u could put some code on the )n_Current of the form. Something like:

comboName = null

Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[KennyUK]

Hey Nick,

Thanks for the reply and suggestion but sadly it did not work.

I have also tried comboName = ""
and comboName.Value = ""

But they did not work either.

Anything else I could try ?

Regards,

Kenny

 

[nickjar2]

Hi Kenny,

It worked fine on mine. I assume u r substitutinmg comboName for the actual name of your combo (I am not being cheeky when I say this)
Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[KennyUK]

Hi Nick,

no you are not being cheeky, its always worth checking these things but let me assure you that I am using the correct combo name.

Cheers,

Kenny

 

[KennyUK]

Hi Guys and Gals,

Still have not fixed this problem - anyone got any suggestions please ??

Thanks in advance,

Kenny

 

[gusbrunston]

Hi...
We ought to be able to work this out!
Using Access2000 or ?
What is your "Row Source Type" from the properties sheet?
What is your "Row Source"?
Do you have a "default" value in the table or properties sheet?
It seems to me that when I put a combo box on a form, it is blank in form view until I make a choice. After making a choice, cboName = "" in the "After Update" event blanks it again.
If this doesn't help, you could send a (very) stripped down database with the form and combo box and maybe we could work it out together.



Gus Brunston
An old PICKer
padregus@home.com