Inserting a 'tick' in a table / form

[Jamie Cox]

I need to be able to enter a 'tick' symbol into a form
entry which I can then mail merge into a school repotr
document. Obviously in Word I just use insert symbol or
rather create a shortcut, but how do I set up the access
form so that I can enter a tick. I tried a yes / no
field entry, but in my mail merge document I get true or
false as my merged text. Any ideas gratefully received

 

[Tim Ferguson]

Obviously in Word I just use insert symbol or
rather create a shortcut, but how do I set up the access
form so that I can enter a tick. I tried a yes / no
field entry, but in my mail merge document I get true or
false as my merged text.

You've conflated about three different things here, each having different
solutions:

- On a form -
You use a checkbox control

- In a query -
You use an IIf() function to convert the logical value to a character like
this:
SELECT Blah, ... IIf(MyField=True,"X","O") AS MyTickField
FROM MyTable
etc etc

(I'm afraid that O and X are the closest I can get with plain text)

- In a mail merge -
You can use an If field in the form letter in pretty much the same way.
<<if <<mergefield "MyField">>
, <<symbol 0223 "Symbol">>, <<symbol 0252 "Webdings">> >>

Hope that helps a bit

Tim F