Search results

Hi Tried to insert the following in the Txt Box Property Sheet in the format line : =IIF(Time_type="EXP",#,##0.00;(#,##0.00);-,£#,##0.00;(£#,##0.00);-) where Time_type is the Table fieldname. Cheers

Hi all, new to the forum and Access and hoping somebody can help. We have a report where we would like to format a field based on a condition within each record to either display a number as Currency or as a number with 2 decimal points, with the added format that if the number is zero it...