How do I display a value amongst other text

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

Guest

Hi

How do I display a vale from a query amongst other text and allow for large
and small entries but not having to use a textbox and labels around which use
a predifined space sometimes creating large gaps. For example

The investment is worth £100,000 over 10 years

rather than

The investement is worth £100,000 over 10 years
 
Try something like this in the Control Source of your text box:
="The investment is worth " & Format([Amount], "Currency") & " over " &
[Duration] & " years"

Note that you need to change the Name property of the text box as well.
Access gets confused if the text box has the same Name as a field, but is
bound to something different.
 
In a text box, put something like...

= "The investment is worth " & [SomeFieldNameHere] & " over 10 year"

Why do you not want to use a text box? What kind of control do you want to
use?

Rick B
 
Back
Top