I calculated a number in a field and I am trying to get the number to format as such:
If the calculated answer is 25, I would like it to format as 25.00 instead of 25

It is calculating as an integer and I do not want it to do that. Also, my table is formatted as a text field and I must keep it this way, so how can I work around this. When I use Val, If I multiply 25.345 * 1, it gives me 25.345. I would like it to give me 25.35 as the answer.


Thanks

Why must you keep it this way?

This application interfaces with another and in order for the spacing, etc. to sync correctly with the other system, this is the way it had to be designed.

I figured it out. I formatted the code with Format(expression, "###0.00")

Thanks

[This message has been edited by JennJenn (edited 06-03-2002).]