printing and editing a numeric field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Farren - 23 Mar 2004 02:03 GMT

I have a numeric field defined as text. Acres, such as
45.7.
when printing the field using mailmerge the field will
print as 45.7 or 45.699999999999* or 45.6000000000000*.
The astrisk in this case is a wild card such as *.*. I
have tried defining the field in several ways but have not
found a solution. Any ideas?

Reply to this Message

macropod - 23 Mar 2004 10:12 GMT

Hi Michael,

Add a numeric picture switch to the field (i.e. \# 0 or \# ,0 or \# 0.0 or
\# ,0.0 etc) to define how you want the field to appear (eg thousands
separators, number of decimal places, etc).

Cheers

> I have a numeric field defined as text. Acres, such as
> 45.7.
[quoted text clipped - 3 lines]
> have tried defining the field in several ways but have not
> found a solution. Any ideas?

Reply to this Message