Display decimal value in textbox

[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

 

[KARL DEWEY]

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.

 

[Keven Denen]

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 -

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

 

[John W. Vinson]

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

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).

 

[KARL DEWEY]

When I mentioned 'Field size' I was refering to the table.

 

[Keven Denen]

When I mentioned 'Field size' I was refering to the table.
--
Build a little, test a little.








- Show quoted text -

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

Keven Denen