Converting tick boxes in report to Word

[gussy]

Hi folks, hopefully a straightforward one:

Simple database: one table, which includes several tick boxes as fields. These tick boxes appear in my report, (whether ticked or not) amongst other fields.

However, when I convert/export to Word, it doesn't recognise the tick boxes and leaves the area blank.

Is there a way around this? How on earth can I get Word to display at least something where a tick box is ticked?

If the worst comes to the worst I'll just have to change the fields where I manually put in an 'X' as a text, but I'd rather not have to.

Appreciate any help, thanks.

 

[neileg]

The 'integration' between Access and Word is pretty poor here, witnessed by the fact that the export file is an rtf not a native Word doc.

The tickbox is an odd data type. On a report, although it shows as a ticked or unticked box, it's not a text character and so when you export it there is no text equivalent.

The only way round this is to use a calculated field in your query that tests your tick box for a yes and returns a text entry such as the tick box symbol in Wingdings. Display this calculated field on the report instead of your tickbox field. If you format this field as Wingdings in your report this will show more or less the same as before, and this character will be exported to Word.