JS-Q2: Missing tick-box

[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.

 

[Keith]

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.

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

 

[Jack Sheet]

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

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.

 

[Keith]

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.

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

 

[Jack Sheet]

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

Oh, Duh! Thanks. I guess that's why I post in gettingstarted :-(

 

[John Vinson]

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.

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]

 

[Jack Sheet]

Thanks John
As you can tell I am very new to all this, but learning fast.

 

[Jack Sheet]

Thanks Bob. Keith solved this for me, but thanks for looking at it.