JS-Q2: Missing tick-box

  • Thread starter Thread starter Jack Sheet
  • Start date Start date
J

Jack Sheet

Hi all. I tried a search but could not find this covered (probably me not
using appropriate keywords)

I imported an Excel 97 workbook into an Access 97 database (File, get
external data).
One of the imported fields had values limited to "TRUE" or "FALSE", and the
intention is that the field should appear as a yes/no tick-box.

The values are all imported as numerical values "-1" (for TRUE) or "0" (for
FALSE), and I can only get them to appear as Yes v No, or On v Off, or True
v False. I cannot get the tick box to appear.

If I create a new field formatted as Yes/No, it does show the tick box, so
it certainly seems to be possible in Access 97.

Thanks for any help.

Please ignore characters "JS-Q2" in subject header.
 
Jack Sheet said:
Hi all. I tried a search but could not find this covered (probably me not
using appropriate keywords)

I imported an Excel 97 workbook into an Access 97 database (File, get
external data).
One of the imported fields had values limited to "TRUE" or "FALSE", and
the intention is that the field should appear as a yes/no tick-box.

The values are all imported as numerical values "-1" (for TRUE) or "0"
(for FALSE), and I can only get them to appear as Yes v No, or On v Off,
or True v False. I cannot get the tick box to appear.

If I create a new field formatted as Yes/No, it does show the tick box, so
it certainly seems to be possible in Access 97.

Thanks for any help.

Please ignore characters "JS-Q2" in subject header.
Click to expand...
What's your question Jack? You seem to have solved your problem by having a
Yes/No field ready to receive the data.

Regards,
Keith.
www.keithwilby.com
 
Keith said:
What's your question Jack? You seem to have solved your problem by having
a Yes/No field ready to receive the data.

Regards,
Keith.
www.keithwilby.com
Click to expand...
Thanks for the help, Keith.
My problem is that when viewing the table in datasheet view the data does
not appear as a tick-box.
It just appears as the narrative "yes" or "no" (or "true" or false" etc,
depending on format selected). The format options in design view do not
appear to contain "Tickbox" as a display option.
 
Jack Sheet said:
Thanks for the help, Keith.
My problem is that when viewing the table in datasheet view the data does
not appear as a tick-box.
It just appears as the narrative "yes" or "no" (or "true" or false" etc,
depending on format selected). The format options in design view do not
appear to contain "Tickbox" as a display option.
Click to expand...
Assuming the data type of the field is "Yes/No" then open the table in
design view, select the field and go to the "lookup" tab - make sure that
it's set to "check box".

HTH - Keith.
www.keithwilby.com
 
Keith said:
Assuming the data type of the field is "Yes/No" then open the table in
design view, select the field and go to the "lookup" tab - make sure that
it's set to "check box".

HTH - Keith.
www.keithwilby.com
Click to expand...

Oh, Duh! Thanks. I guess that's why I post in gettingstarted :-(
 
The values are all imported as numerical values "-1" (for TRUE) or "0" (for
FALSE), and I can only get them to appear as Yes v No, or On v Off, or True
v False. I cannot get the tick box to appear.
Click to expand...

I see you got the solution but...

Table datasheets have VERY limited functionality. They're designed for
debugging and design, not for data presentation or editing. If you
create a Form bound to your table, you can use a checkbox, Combo Box,
toggle button, textbox, etc. etc. for this yes/no field. The table
view is pretty much irrelevant.

For what it's worth, a Yes/No field is always actually stored as -1
for Yes, 0 for No, regardless of the display format.

John W. Vinson[MVP]
 
Back
Top