Format Text Box

T

Tandy

Hi! Ok, let me try to explain what I am doing. I am making a report that when
it is opened prompts the user to "Type Rate per Hour of Reimbursement." I did
this by creating a text box named "RebursementRate" with the control source
"Type Rate per Hour of Reimbursement." Then I have another text box named
"SumOvertime&ReimbursementRate" with the control source
"=Sum([Overtime])*[Type Rate per Hour for Reimbursement]." All the numbers
come out great, but I would like them to be in currency format. Example
$2,000.50 instead of 2000.5. I tried using the changing format to currency in
the properties but it doesn't do anything. I was wondering if I could do
something like when you use Format$([Type Start Date],"mmmm yyyy",0,0) for
your control source to get a 1/1/2005 start date to read January 2005. Sorry
this is so lengthly!
Thanks,
Tandy
 
D

Duane Hookom

You can set the format property and if that doesn't work, consider changing
the control source to

=Val( Sum([Overtime])*[Type Rate per Hour for Reimbursement])
 
T

Tandy

Duane,

I tried what you suggested but it didn't do what I wanted. The value I
wanted in currency is actually in a string in the control source of the text
box as follows:

="Please reimburse us for " & Sum([Overtime]) & " at " & [ReimbursementRate]
& " or " & [SumOvertime&ReimbursementRate] & " for " & Format$([Type Start
Date],"mmmm yyyy",0,0) & " ER Overtime. "

I need both ReimbursementRate and SumOvertime&ReimbursementRate in currency.
I changed their textbox properties to currency, which works, but it doesn't
show up in the string above.

I really appreciate your help!

Tandy
 
D

Duane Hookom

I missed the concatenation of string/text information in your first post.

Does this work for you?

="Please reimburse us for " & Sum([Overtime]) & " at " &
Format([ReimbursementRate],"currency") & " or " &
Format([SumOvertime&ReimbursementRate],"currency") & " for " & Format$([Type
Start Date],"mmmm yyyy",0,0) & " ER Overtime. "
 
T

Tandy

Hey Duane! You didn't miss the concatenation of string/text information. I
didn't mention it because I thought that would make my post too confusing and
I would be able to figure it out myself with a little help. Sometimes I
forget I'm not that great with Access! :D Anywho, your suggestion is exactly
what I needed. Thank you for your all of your help. My report is done and
looks great, exactly how I wanted! I really appreciate your help!
Thanks again,
Tandy

Duane Hookom said:
I missed the concatenation of string/text information in your first post.

Does this work for you?

="Please reimburse us for " & Sum([Overtime]) & " at " &
Format([ReimbursementRate],"currency") & " or " &
Format([SumOvertime&ReimbursementRate],"currency") & " for " & Format$([Type
Start Date],"mmmm yyyy",0,0) & " ER Overtime. "


--
Duane Hookom
MS Access MVP
--

Tandy said:
Duane,

I tried what you suggested but it didn't do what I wanted. The value I
wanted in currency is actually in a string in the control source of the
text
box as follows:

="Please reimburse us for " & Sum([Overtime]) & " at " &
[ReimbursementRate]
& " or " & [SumOvertime&ReimbursementRate] & " for " & Format$([Type Start
Date],"mmmm yyyy",0,0) & " ER Overtime. "

I need both ReimbursementRate and SumOvertime&ReimbursementRate in
currency.
I changed their textbox properties to currency, which works, but it
doesn't
show up in the string above.

I really appreciate your help!

Tandy
Click to expand...
Click to expand...
 
Top