Print Blank Check

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

on my form there is a control named expconeng where it calculates the value
of the control expnetpay and shows as a english currency value.
i.e. $50.00 is Fifty Dollars
I want to be able to print a Blank Check though and not show No Dollars and
No Cents, just Blank.

ExpConEng: ConvertCurrencyToEnglish([ExpNetPay]) is in the query grid
for the control expconeng

Can I do this?
Report is unbound and simply equals the form.
 
You could alter the function ConvertCurrencyToEnglish to treat 0.0
differently. That's not a function built into Access, so it must be defined
somewhere in your application.
 
Dave Elliott said:
on my form there is a control named expconeng where it calculates the
value of the control expnetpay and shows as a english currency value.
i.e. $50.00 is Fifty Dollars
I want to be able to print a Blank Check though and not show No
Dollars and No Cents, just Blank.

ExpConEng: ConvertCurrencyToEnglish([ExpNetPay]) is in the query
grid for the control expconeng

Can I do this?
Report is unbound and simply equals the form.
Click to expand...

You could rename the control from "ExpConEng" to "txtAmount" -- or
something like that; you must rename the control but it doesn't much
matter to what -- and change its ControlSource property from

ExpConEng

to

=IIf([ExpConEng] = "No Dollars and No Cents", "", [ExpConEng])

You'd have to do this on both the form and the report, if you want them
to behave the same.
 
Back
Top