<div>
thanks for the replies, I didnt notice until just now that both replies were from the same expert! doh! anyway the general number didnt seem to work, but the second one worked like a charm. I may have not done the general number thing right, but I like the formatnumber solution better anyhow, thanks alot.
</div>


thanks for the replies, I didnt notice until just now that both replies were from the same expert! doh! anyway the general number didnt seem to work, but the second one worked like a charm. I may have not done the general number thing right, but I like the formatnumber solution better anyhow, thanks alot.

<div>
<div class="content wysiwyg-content">
I have a data access page that used boundspans to refernce a database. The data has decimals and want to set the boundspan to a fixed format with no decimals but cant figure out how. I have the format set to fixed for the boundspan but cant find where it lets me choose how many decimal point to show. Anybody have any ideas?<br />
Thanks
</div>
</div>


I have a data access page that used boundspans to refernce a database. The data has decimals and want to set the boundspan to a fixed format with no decimals but cant figure out how. I have the format set to fixed for the boundspan but cant find where it lets me choose how many decimal point to show. Anybody have any ideas?
Thanks

FIXED FORMAT IN A BOUNDSPAN ON DATA ACCESS PAGE

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.