Can't set decimal places

[Guest]

I have searched the posts and done everything they have said. But my report
still does not show two decimal places with a dollar sign. I have set it to
currency, auto, 2 decimal places. I have typed $#.00, $##.00, etc. Why is
this so difficult!!!!!!! By the way, I am very frustrated!!!! Thank you
very much in advance for your help!

 

[Rick Brandt]

I have searched the posts and done everything they have said. But my
report still does not show two decimal places with a dollar sign. I
have set it to currency, auto, 2 decimal places. I have typed $#.00,
$##.00, etc. Why is this so difficult!!!!!!! By the way, I am very
frustrated!!!! Thank you very much in advance for your help!

What is the ControlSource of the TextBox in question?

 

[Guest]

=Trim([Due date] & " $" & [PaymentAmount])

What is the ControlSource of the TextBox in question?

 

[John Spencer]

=Trim([Due date] & " " & Format([PaymentAmount],"Currency")

Since you've turned the control's contents into a string with your
statement, the control's number formatting property will not work to format
this as a number. However, you can use the Format function to accomplish
this. See above.

=Trim([Due date] & " $" & [PaymentAmount])

What is the ControlSource of the TextBox in question?

 

[Guest]

You are the best!!!!! It worked!!!!

That string in the control contents was put there by the program. I am very
much a novice with Access and there is no way I could have come up with that
on my own. For future reference, is there another, easier way to do the
exact same thing? I mean, one that you don't need to know Access'
programming language. )

=Trim([Due date] & " " & Format([PaymentAmount],"Currency")

Since you've turned the control's contents into a string with your
statement, the control's number formatting property will not work to format
this as a number. However, you can use the Format function to accomplish
this. See above.

=Trim([Due date] & " $" & [PaymentAmount])

Megan wrote:
I have searched the posts and done everything they have said. But my
report still does not show two decimal places with a dollar sign. I
have set it to currency, auto, 2 decimal places. I have typed $#.00,
$##.00, etc. Why is this so difficult!!!!!!! By the way, I am very
frustrated!!!! Thank you very much in advance for your help!

What is the ControlSource of the TextBox in question?

 

[Douglas J Steele]

No, there's no simpler way to do it. If you want to concatenate two separate
fields as your ControlSource, you cannot use the Format property anymore.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

You are the best!!!!! It worked!!!!

That string in the control contents was put there by the program. I am very
much a novice with Access and there is no way I could have come up with that
on my own. For future reference, is there another, easier way to do the
exact same thing? I mean, one that you don't need to know Access'
programming language. )

=Trim([Due date] & " " & Format([PaymentAmount],"Currency")

Since you've turned the control's contents into a string with your
statement, the control's number formatting property will not work to format
this as a number. However, you can use the Format function to accomplish
this. See above.

=Trim([Due date] & " $" & [PaymentAmount])

:

Megan wrote:
I have searched the posts and done everything they have said. But my
report still does not show two decimal places with a dollar sign. I
have set it to currency, auto, 2 decimal places. I have typed $#.00,
$##.00, etc. Why is this so difficult!!!!!!! By the way, I am very
frustrated!!!! Thank you very much in advance for your help!

What is the ControlSource of the TextBox in question?