Separating a field value.

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

 

[Douglas J Steele]

The dollars will be Int(Field). The cents will be Field - Int(Field)

 

[Rick Brandt]

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.

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.

 

[Douglas J Steele]

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