Display decimal value in textbox

  • Thread starter Thread starter Trupti
  • Start date Start date
T

Trupti

Hi friends,
I have form which contain text boxes..i use MS Access database..i have
curreancy field in database.i want to display value of this field in
textbox..But textbox is not showing decimal value..Textbox only show value
before decimal
 
What is the 'Field size' property set to?
If it is 'Long Integer' then you know that integers are whole number and
have no decimal places.
 
What is the 'Field size' property set to?
If it is 'Long Integer' then you know that integers are whole number and
have no decimal places.

--
Build a little, test a little.





- Show quoted text -
Click to expand...

It's a text box, it doesn't have a field size property.

Trupti, right click on the text box in design view, go to the format
tab and make sure it is set to Currency. If it is, also check the
Decimal Places property. It should either be set to Auto or however
many decimal places you want to show.

Keven Denen
 
Hi friends,
I have form which contain text boxes..i use MS Access database..i have
curreancy field in database.i want to display value of this field in
textbox..But textbox is not showing decimal value..Textbox only show value
before decimal
Click to expand...

In addition to Karl's and Keven's suggestions... doublecheck the field type
*in the Table* (not the form). If the field is a Number... Long Integer
datatype, then it will not have any decimal places; the currency Format is
irrelevant in this case, as it only controls how the field value is displayed,
not what's stored. You should use a Currency Datatype (instead of any sort of
Number datatype).
 
When I mentioned 'Field size' I was refering to the table.
--
Build a little, test a little.








- Show quoted text -
Click to expand...

The OP stated that it was a Currency field, Currency fields don't have
field sizes either.

Keven Denen
 
Back
Top