Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limiting the number of decimal places in an unbound textbox

Status
Not open for further replies.
demon147

demon147

Technical User
Jun 29, 2001
30
0
0
CA
I want to limit the number of decimal places to 1 in an unbound text box but when I right click and choose properties and select decimal places to 1 the calculation still gives me all of the decimal places.


Help appreciated.

Thanks
 
Sort by date Sort by votes
Let's assume you're using the following to populate the text box:

=([Str1]*[Str2])

Change your formula to = format(([Str1]*[Str2]),"##.#")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
105
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
107
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
108
dhookom
dhookom
GPnew
  • Locked
  • Question
Give each line in group the same number on a report line 1
Replies
10
Views
120
GPnew
GPnew
renigar
  • Locked
  • Question
Access 365 Report use nickname if exist instead of 1st name
Replies
4
Views
153
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top