You need an expression like the following
English(Int([SomeFieldName]) & " and " &
Format([SomeFieldName]-Int([SomeFieldName],"00") & "/100"
If you want to use that as the control's source then put an equal sign in
front of it AND make sure the control does not have the same name as the field.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
I created a module named "CurrencyToText" and copied this code into it. I
have a textbox named "GrandTotal" on a report named "FormalQuote" that I need
to be reformatted. How is the module called to reformat this textbox number?