Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

FIXED FORMAT IN A BOUNDSPAN ON DATA ACCESS PAGE

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
0
norrin_radd
Asked:
norrin_radd
  • 3
2 Solutions
 
mbizupCommented:
If you don't want decimals,  set the format to General Number
0
 
mbizupCommented:
you can also set the decimal places using a formatNumber statement in the controlsource property:

= formatnumber(x,0)
= formatnumber(x,3)
etc.
0
 
norrin_raddAuthor Commented:
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.
0
 
mbizupCommented:
Glad to help!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now