Concatenated string doesn't show decimals

[delph]

Hi all,

I wonder if anyone can help. I have an update query that updates a diary table with the payment reason concatenated with the payment amount. It works fine but if the payment amount is no pence ie. £5.00, it just shows £5.

If the payment amount is £5.52, it shows £5.52. I want to get it to show the .00 if there is no pence & just cannot get it to do so.

Can anyone point me in the right direction?

Many thanks, Sue

 

[vbaInet]

Change the Format property and the Decimal Places property of the display control on the form or field in the table.

 

[delph]

Hi,

I've tried changing the format property of the table field and the subform field to currency & decimal to auto but it still doesn't show the decimals if they are zero. Any other ideas?

 

[vbaInet]

Hi,

I've tried changing the format property of the table field and the subform field to currency & decimal to auto but it still doesn't show the decimals if they are zero. Any other ideas?

Try Decimal to 2 decimal places.

 

[delph]

Hi, thanks for the advice. I think the problem may be that I have a table, Diary with a field called Diary Entry. This is formatted to memo as users may need to input more than 50 characters. There is another table, Payments with fields called Payment Reason and Payment Amount. I've changed the Payment Amount field so it's properties are format currency and decimal to 2 and changed the subform diary entry field to have decimal 2 but it still doesn't display the zero decimal. I have an update query that runs every time a payment is input that puts an entry in the Diary to show the payment reason concatenated with the payment amount but this will only show the full decimal amount if it's not zero. For example, a payment of £37.50 shows in the Diary as £37.5 missing the last zero.

Grateful for any suggestions.

Thanks, Sue

 

[vbaInet]

Just confirming you have it like this Sue. See the attachments. It works with the way it was set. Remember for it to show on the form as currency, you must do it on the text boxes as well.