Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access value list not showing right columns in datasheet

Posted on 2016-11-20
3
Medium Priority
?
38 Views
Last Modified: 2016-11-25
Hello experts -
I am stuck - I have programmed a table to show a combo box based on a value list, using the values below.
The problem, as illustrated in the second screenshot, is that the program is not parsing the values correctly - I have tried enclosing each option in quotation marks, but it makes no difference.
Specifically: the value '1' appears, while the others display the right field value. AND I am unable to manually select the first option while in datasheet view (I can select the other values).

Here is the text for the value list options:
1;GN;Global rates negotiated (no exceptions);2;GG;Global guideline (allow exceptions-otherwise default here);3;GL;Guideline (not negotiated- exceptions OK);4;BN;Use Benchmark (not negotiated);5;GF;GRANDFATHERED - UPDATE DATA


Any ideas?
Many thanks!
image1
image2
0
Comment
Question by:terpsichore
[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
  • 2
3 Comments
 
LVL 40

Expert Comment

by:als315
ID: 41894636
Can you upload sample DB?
0
 

Accepted Solution

by:
terpsichore earned 0 total points
ID: 41894684
I found the problem - the SHOW COLUMN HEADS must be FALSE - otherwise it treats the first row as column heads. I fixed this. Thank you in any case!
0
 

Author Closing Comment

by:terpsichore
ID: 41901392
simple error
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

660 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