Printing Os and 0s (zeros) 1

[smdemo]

I have created a database that prints a coversheet that a third party vendor will then enter in their system. My problem is that this is handled in a foreign country that does not know English and they confuse O and 0. I have looked through all my fonts to find a zero font that has the diagonal line through it and am unable to find one. Does anyone have a solution to this?

Thanks!

 

[dhookom]

I found one font on my PC that does this Fixedsys.

Since this is for reports, you could possibly use a fixed font such as courier and overlay two transparent text boxes. One of the text boxes would be all spaces other than the zeros which would be replaced by /.

Duane MS Access MVP

 

[dhookom]

I just created a sample report of just the Freight field from the Orders table in Northwind.
Text Box 1:
Control source: =Replace(Format([Freight],"Currency"),"0","/")
Text Box 2:
Control source: =Format([Freight],"Currency")

Both text boxes:
Back Style: Transparent
Font: Courier New
Text Align: Right
Font Size: the same
Top, Left, Height, and Width: the same

This draws a diagonal line through each 0.


Duane MS Access MVP

 

[smdemo]

Works like a charm, thank you very much.