To Avoid Blank Space in Combo Box

[Husain Nagri]

Hi,

Well i have a form with a combo box which takes stores the city names of
world.now sum of the cities has been entered and sum which not been entered
are been taken from user, it retirvied the values from query in indeeds store
in field

well the problem cums many times user leaves blank ,so even blank space row
is been added to combo box. so the next user who enters gets as many as Blank
space row in combo box.

pls help me out how do i solve this

Regards

Husain

 

[Steve Schapel]

Husain,

Perhaps the best approach is prevent the user from entering a record
with a blank.

One way to do this is:
Go to the design view of the table.
Select the field which is being left blank.
In the Validation Rule property, enter:
Is Not Null
In the Validation Text property, enter the message to show the user when
they leave blank.

I'm not sure if this will serve the purpose, as I don't know enough
information about your database, but please give it a try.

 

[Craig]

You can do a delete query where the city is null when the form closes.