We help IT Professionals succeed at work.
Get Started

Form Dropdown Box Field Values - Problem with Spaces in values

tometh asked
Last Modified: 2013-12-24
I have a form with a drop down box (5 potential choices).

Upon attempting to retrieve the Information it appears that I cannot search for any of the entry values (I get "No records returned") that have Spaces in the Values.  The drop down box maps to a text field in the database (all of this created with the DRW - FrontPage 2003).

For Instance the Drop Down Box has the Following Options and Values;

Choice                              Selected                 Value
---------                            -------------             --------
Affiliated Providers                  NO                   Affiliated Providers
Specialists                              NO                   Specialists
Hospitals                                NO                   Hospitals
Mental Health Network            NO                   Mental Health Network
Ancillary Providers                  NO                   Ancillary Providers

When I create a Results Page Searching for Affiliated Providers or Mental Health Network I get No Records Returned -But if I search for Specialists or Hospitals it works fine (there are no spaces - If I change the Values to insert the underscore for the spaces between the words it works fine.  Unfortunately I want to return and display those values without the underscore.

The data is actually being recorded in the database fine!
Watch Question
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE