Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 43
  • Last Modified:

Access value list not showing right columns in datasheet

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
terpsichore
Asked:
terpsichore
  • 2
1 Solution
 
als315Commented:
Can you upload sample DB?
0
 
terpsichoreAuthor Commented:
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
 
terpsichoreAuthor Commented:
simple error
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now