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
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