Solved

Drop down box question

Posted on 2001-08-22
7
164 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
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.

 
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

Suggested Solutions

Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
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 make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

679 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