Set format property in control statement?

  • Thread starter Thread starter Chips
  • Start date Start date
C

Chips

Using Access 2K.

As I recall from a few years ago, I found out how to set the format in a
control statement that would affect say, a number within a concatenated
string.

Like: {="Net Payroll Check: " & [WECheck]} where [WECheck] is a number
that I want formatted to "0.00". I can't find the old db I did it in, and
can't find it in help.

If I just set the control format for 0.00 it doesn't work. Probably because
of the concatenated text.

As I recall I previously stumbled on it, possibly in a book, not like it was
obvious.

Anyone know how to do this?

Per my recollection it was something like ="Net Payroll Check: " &
Format(0.00,[WECheck]). Unfortunately, this doesn't work as I tried it.

Thanks,

GC
 
Chips,

Did you try ="Net Payroll Check: " & Format([WECheck], 0.00)? or
="Net Payroll Check: " & Format([WECheck],"Currency")?

Brian
 
Thanks, the "currency" works. When I try "0.00" it changes it to "Fixed"
which also works, sans $.

GC


Brian Bastl said:
Chips,

Did you try ="Net Payroll Check: " & Format([WECheck], 0.00)? or
="Net Payroll Check: " & Format([WECheck],"Currency")?

Brian


Chips said:
Using Access 2K.

As I recall from a few years ago, I found out how to set the format in a
control statement that would affect say, a number within a concatenated
string.

Like: {="Net Payroll Check: " & [WECheck]} where [WECheck] is a number
that I want formatted to "0.00". I can't find the old db I did it in, and
can't find it in help.

If I just set the control format for 0.00 it doesn't work. Probably because
of the concatenated text.

As I recall I previously stumbled on it, possibly in a book, not like it was
obvious.

Anyone know how to do this?

Per my recollection it was something like ="Net Payroll Check: " &
Format(0.00,[WECheck]). Unfortunately, this doesn't work as I tried it.

Thanks,

GC
 
Back
Top