Separating a field value.

M

Mike Dixon

I have a field currency value($1.99) and I need to separate the cents part
into a separate field so I can reduce the font size on a stock label. The
final label should have a large $1 with a smaller .99.
Can anyone provide me with some guidance on this?
Thanks.
 
R

Rick Brandt

Mike said:
I have a field currency value($1.99) and I need to separate the cents
part into a separate field so I can reduce the font size on a stock
label. The final label should have a large $1 with a smaller .99.
Can anyone provide me with some guidance on this?
Thanks.
Click to expand...

This is for a Report I assume?

Use two TextBoxes side by side. The first should have text right-justified and
the second left-justified. In the first one use expression...

=Fix([YourFieldName])

....and in the second...

=[YourFieldName] - Fix([YourFieldName])

Then set the fonts as desired.
 
D

Douglas J Steele

If the currency values can be negative, Rick's suggestion of using Fix is
better than using Int.
 
Top