simple formatting


F

fishqqq

I have a text field (where the underlaying table field is set to text
and not number) and i am trying to limit the decimal place of a number
i am populating this field with to 2 decimals.

i know if the field was a Number field instead of a text field this
would not be a problem but how do i get Access2010 to round up to 2
decimals when this isn't set to a number field ( i need this field to
be a text field)

when i set the format option of the field (in the form) to :
([Budget], 2)
before i save it access automatically changes it to "([Bu"d"get], 2)"

how do i set the format to show only 2 decimals???

btw sometimes i need this field populated to read NO BUDGET which is
why it is set as a text field and not number field

thanks
Steve
 
Ad

Advertisements

Joined
Feb 9, 2012
Messages
25
Reaction score
0
You can't format what's in the box instead you need to write it into the textbox already formatted so the number stored is 2.35 or whatever.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple workings 4
Simple Formula 2
simple solution 0
simple question? 1
Simple Question 2
simple relation... 3
A simple question 5
Simple but profound 7

Top