second numeral after decimal point to showing

W

W E B G U R L

second numeral after decimal point to showing

e.g 59.5 instead of 59.50

Data type is set to currency
Decimal places set to 2



Thanks for any help given!
 
A

Andi Mayer

second numeral after decimal point to showing

e.g 59.5 instead of 59.50

Data type is set to currency
Decimal places set to 2
Click to expand...
Where??????
lets asume its on a form, then set the control format to standard and
decimal places to 2
 
J

John Vinson

second numeral after decimal point to showing

e.g 59.5 instead of 59.50

Data type is set to currency
Decimal places set to 2
Click to expand...

What is your question?

You've made two statements. It's not clear what you are asking.

John W. Vinson[MVP]
 
W

W E B G U R L

In my database I have the price 59.50

In design view I have the datatype set to standard with decimal places set to 2 (as per
previous NG posting advice)

When I view my webpage the price shows as 59.5


Sorry for not being very clear!




second numeral after decimal point to showing

e.g 59.5 instead of 59.50

Data type is set to currency
Decimal places set to 2
Click to expand...

What is your question?

You've made two statements. It's not clear what you are asking.

John W. Vinson[MVP]
 
J

John Vinson

In my database I have the price 59.50
Click to expand...

Well... nitpicky, but in fact you don't. You have the price stored in
a currency field which is a 64-bit binary scaled integer. It may be
DISPLAYED as 59.50 but those characters are not what is stored in the
table.
In design view I have the datatype set to standard with decimal places set to 2 (as per
previous NG posting advice)

When I view my webpage the price shows as 59.5
Click to expand...

Set the Format property of the webpage textbox. I haven't worked much
with webpages so I'm not absolutely sure how one would do so, but if
there's a Format property set it to #.00 or to $#.00.

John W. Vinson[MVP]
 
W

W E B G U R L

Thanks John, I have appreciated your help.

Yes, I did try that and it solved the problem after mucking around with access



In my database I have the price 59.50
Click to expand...

Well... nitpicky, but in fact you don't. You have the price stored in
a currency field which is a 64-bit binary scaled integer. It may be
DISPLAYED as 59.50 but those characters are not what is stored in the
table.
In design view I have the datatype set to standard with decimal places set to 2 (as per
previous NG posting advice)

When I view my webpage the price shows as 59.5
Click to expand...

Set the Format property of the webpage textbox. I haven't worked much
with webpages so I'm not absolutely sure how one would do so, but if
there's a Format property set it to #.00 or to $#.00.

John W. Vinson[MVP]
 
Top