Solved

Drop down box question

Posted on 2001-08-22
7
162 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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…
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 exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

910 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

21 Experts available now in Live!

Get 1:1 Help Now