Multiple Formats in Calculated Text Box

  • Thread starter Thread starter PPCO
  • Start date Start date
P

PPCO

I have a text box that is based on three other calculated text boxes. I'm
trying to get it to read like this: 5/10=50%. The [GoalPercentage] text box
is formatted as a percent, but it won't bring that format over to the
statement. For example it's reading 8/14=0.57142857.
I want the [GoalPercentage] part of the expression to be a percent. I've
tried formatting the text box as a percent, but that doesn't work. Following
is the statement.


=[NumberofGoalsReached] & "/" & [TotalNumberofGoals] & "=" & [GoalPercentage]

Thanks!
 
=[NumberofGoalsReached] & "/" & [TotalNumberofGoals] & "=" &
Format([GoalPercentage],"Percent")
 
Great! Figured it was something like that, but just couldn't figure out the
exact code. One more quick one: Can I also limit the [GoalPercentage] part of
the expression to 0 decimal places? Thanks!

Duane Hookom said:
=[NumberofGoalsReached] & "/" & [TotalNumberofGoals] & "=" &
Format([GoalPercentage],"Percent")

--
Duane Hookom
Microsoft Access MVP


PPCO said:
I have a text box that is based on three other calculated text boxes. I'm
trying to get it to read like this: 5/10=50%. The [GoalPercentage] text box
is formatted as a percent, but it won't bring that format over to the
statement. For example it's reading 8/14=0.57142857.
I want the [GoalPercentage] part of the expression to be a percent. I've
tried formatting the text box as a percent, but that doesn't work. Following
is the statement.


=[NumberofGoalsReached] & "/" & [TotalNumberofGoals] & "=" & [GoalPercentage]

Thanks!
Click to expand...
Click to expand...
 
Nevermind, got it : Format([GoalPercentage],"0%")

PPCO said:
Great! Figured it was something like that, but just couldn't figure out the
exact code. One more quick one: Can I also limit the [GoalPercentage] part of
the expression to 0 decimal places? Thanks!

Duane Hookom said:
=[NumberofGoalsReached] & "/" & [TotalNumberofGoals] & "=" &
Format([GoalPercentage],"Percent")

--
Duane Hookom
Microsoft Access MVP


PPCO said:
I have a text box that is based on three other calculated text boxes. I'm
trying to get it to read like this: 5/10=50%. The [GoalPercentage] text box
is formatted as a percent, but it won't bring that format over to the
statement. For example it's reading 8/14=0.57142857.
I want the [GoalPercentage] part of the expression to be a percent. I've
tried formatting the text box as a percent, but that doesn't work. Following
is the statement.


=[NumberofGoalsReached] & "/" & [TotalNumberofGoals] & "=" & [GoalPercentage]

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top