Help on Monetary figures

06-30-05, 11:49 AM

Adam Harding

Someone must know but not me. Can i get my figure amounts to only display to
2d.p. while it is linked back to an access dbase?

Thanks in advance

06-30-05, 04:58 PM

Renee in Juneau

FWIW, I've only done one Infopath form linking to an Access database,
but I finally ended up changing almost all the fields (in Access) to
text, and then used the Infopath form to do all the validation and
data massage (including setting decimal points).

It worked rather well, once I had succumbed to the different mindset.

On Thu, 30 Jun 2005 03:49:05 -0700, Adam Harding
<AdamHarding> wrote:
[..]

07-01-05, 09:17 AM

Adam Harding

Me too but am on my 4/5th access linked form now but the first requiring
monetary figures and because i am calculating VAT to 8 d.p. it displays all
the results to 8 d.p. i can make the physical size of the field smaller but
then if the entry is 100 or more it would only show 1 d.p.

How have you managed the data massaging i can get the d.p. no problem but
restricting it in infopath is proving diffuclt

"Renee in Juneau" wrote:
[..]

Similar Threads
how do i subtract figures in attendance from the figures in capac.
Changing positive figures to minus figures I have a large worksheet with numbers already entered onto it, as positive numbers, however, I want to change all these to minus figures. Is there an easy way to do this...
How to convert figures to text to display an answer in figures an.
how to check one row of figures against a second row of figures and highlight dupes Hi all, first post so thanks for any and all help. I want to get Excel to check one row of figures against a second row of figures and get it to highlight any duplicates,...
Figures disapear in Word after Updating table of figures. Does anybody have a solution to this problem? When I update the table of figures in my document, the images disapear and are replaced with an empty canvas.