combo box question

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Ive read threw a BUNCH of combo box issues, most of which say, strip off the
formating to fix the issue. But none have been about the Bit fields
displaying -1 or 0 instead of Yes No. Has any one else found a fix for this
issues since sp3 ?
thanks jon

fyi - more reading
http://support.microsoft.com/kb/945280/en-us
 
Ive read threw a BUNCH of combo box issues, most of which say, strip off the
formating to fix the issue. But none have been about the Bit fields
displaying -1 or 0 instead of Yes No. Has any one else found a fix for this
issues since sp3 ?
thanks jon
Click to expand...

See if the recent Microsoft hotfix resolves the problem:


http://support.microsoft.com/kb/945674

If not, you could create a combo box with two columns; set its RowSourceType
to Value List and its RowSource to

-1;"Yes";0;"No"

If the Column Count is 2, bound column 1, and ColumnWidths something like

0;.25

you'll see Yes and No but store -1 and 0.

John W. Vinson [MVP]
 
Back
Top