Solved

Drop down box question

Posted on 2001-08-22
7
165 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

739 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