Solved

Drop down box question

Posted on 2001-08-22
7
161 Views
Last Modified: 2013-12-24
I have a drop down box populated from an MS Access table but I want the first entry to be blank. At the moment, unless another entry in the drop down box is selected, the first entry in the table is always visible and is therefore selected when submitted with the form. I want to do this without adding a blank entry into the Access table.
Any Ideas??
0
Comment
Question by:rezzer
  • 4
  • 3
7 Comments
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6413062
Are you coding the ASP yourself or using a wizard?

Show me the code for your drop down.
0
 
LVL 1

Author Comment

by:rezzer
ID: 6422630
ClassyLinks,
I'm using a wizard which gives me the required results from the Access DB but I want to add a blank above the selections so when nothing is selected nothing gets submitted. I try to do it with FORM FIELD PROPERTIES and then ADD CHOICE but then a choice field is required which can't be left blank(or white space)

Any help greatly appreciated

Rezzer
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6422663
Why not make that choice something like:

Please select an option

and leave the value blank (don't check off the box)

That way, nothing will be submitted to the db for that field if they don't select anything.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 1

Author Comment

by:rezzer
ID: 6431360
So there's no way to leave choice blank?
0
 
LVL 7

Accepted Solution

by:
ClassyLinks earned 50 total points
ID: 6431671
Just spaces...but that might not work in Netscape, and it would add a blank entry to the db, as you have already discovered.
0
 
LVL 1

Author Comment

by:rezzer
ID: 6431718
OK, thanks for your help

Rezzer
0
 
LVL 7

Expert Comment

by:ClassyLinks
ID: 6431986
NP....c u next time!  8-)
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now