Prev: Preventing Form from moving
Next: combo box and saving to table
From: JohnM77 via AccessMonster.com on 4 Nov 2009 16:29
Excellent. That did the trick! Thanks for your help. You've helped me before,
too. I truly appreciate your time and effort.

Best regards,
John

Dirk Goldgar wrote:
>> Thanks for your reply, Dirk. I just tried the ROund function like this,
>>
>[quoted text clipped - 5 lines]
>> in
>> the original table is number/single.
>
>Interesting. When I do this with Doubles, it comes out looking pretty good,
>but not with Singles. I suspect the problems have to do with the relative
>precisions of the data types.
>
>Try this: forget the Round function, and modify the Format and Decimal
>Places properties of the field in the query. In query design view, click on
>the field in the grid, then press Alt+Enter or click the toolbar button to
>open the property sheet for the field. Set the Format property to "Fixed"
>and the Decimal Places property to 2. That should cause the field values to
>be displayed by the queries with two decimal places, except when the field
>has the datasheet's focus. Does that serve your needs well enough? It
>doesn't round the actual value, but causes it to display as rounded.
>

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2
Prev: Preventing Form from moving
Next: combo box and saving to table