Problem showing #s on a form

[R Massie]

Hello:

I've got a database that I've made with three subforms on
the data entry page. The problem is that I would like the
calculated values to show up consistently such
as .99447202 instead of .994472022668 and 38457.24 instead
of 38457.242568421575. I know that this should be a minor
fix. but on this one issue I have no idea what to make the
change on. I've tried changing things on the form, table,
query and now it's out of control with some values that I
need a decimal on just showing up as 38457 instead of
38457.24.

Thank you

Robert

 

[Jeff Boyce]

What "things" have you tried changing? Changing how?

Whenever you have a form displaying a number in a control, you can set the
format of that control. Have you tried changing format to Fixed, Decimal
places to 2?

 

[Guest]

Hello Jeff:

It worked. Thank you. This was my first DB project for a
new job. This DB is full of nested queries and macros that
I had no problem with, but this simple intro to access
stuff had me stumped. You've saved my reputation.

Robert

 

[Jeff Boyce]

Robert

You are welcome. If I'd known I was helping with a reputation, I would have
asked what kind of rep you were after... <g>

Jeff Boyce
<Access MVP>