Format Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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])
 
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
 
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. "
 
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...
 
Back
Top