Trouble Formatting a Formula?

[Guest]

I have a check box if the pay is hourly. I don't want an hourly figure in
this column, so I created this formula

Hourly Wage: IIf([Hourly Rate]=-1,[Units]*[Time],"")

It works, but I'm unable to format it. When I click the field properties,
the dropdown list is empty? If I take out the Iif, I am able to format with
the drop down list appearing & working fine.

If anyone could help me out, I'd REALLY appreciate it. THANKS!!!!!!! Rita

 

[Duane Hookom]

You can't expect to format "" using a numeric format. You might want to try:
Hourly Wage: IIf([Hourly Rate]=-1,[Units]*[Time],Null)
or
Hourly Wage: IIf([Hourly Rate]=-1,[Units]*[Time],0)
--
Duane Hookom
MS Access MVP


"Mail Recipients Changing order of fields"