B
Beau
I've just converted an adp from Access 2000 to Access
2002. There seems to be a problem with the currency
format on calculated fields (happens when they're
calculated in the form or even in an underlying VIEW).
Even though the form or report control has currency
specified as the format, the values are basically
unformatted. I was able to get the currency format to
display using the Format(Field, "Currency) method, but
then if I add the fields, they're treated as though their
text and presented one string followed by the next.
I tried searching for this in the MS Knowledge Base and
found nothing. Any help would be most appreciated.
Beau
(e-mail address removed)
2002. There seems to be a problem with the currency
format on calculated fields (happens when they're
calculated in the form or even in an underlying VIEW).
Even though the form or report control has currency
specified as the format, the values are basically
unformatted. I was able to get the currency format to
display using the Format(Field, "Currency) method, but
then if I add the fields, they're treated as though their
text and presented one string followed by the next.
I tried searching for this in the MS Knowledge Base and
found nothing. Any help would be most appreciated.
Beau
(e-mail address removed)