field within label

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

Guest

Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?

Example:
Record 1
Site Name: Auckland
Label: Bearing from Auckland to Parent Site:

Record 2
Site Name: Wellington
Label: Bearing from Wellington to Parent Site:
 
Hi Nikki,

instead of using a label, how about using a textbox control

controlSource --> = "Bearing from " & [Daughter Site] & " to Parent Site:"

If this is being done on a form and it is a continuous form, put the
calculation in the underlying recordset...

field --> SiteLabel: "Bearing from " & [Daughter Site] & " to Parent Site:"

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Perfect Thanks!


strive4peace said:
Hi Nikki,

instead of using a label, how about using a textbox control

controlSource --> = "Bearing from " & [Daughter Site] & " to Parent Site:"

If this is being done on a form and it is a continuous form, put the
calculation in the underlying recordset...

field --> SiteLabel: "Bearing from " & [Daughter Site] & " to Parent Site:"

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?

Example:
Record 1
Site Name: Auckland
Label: Bearing from Auckland to Parent Site:

Record 2
Site Name: Wellington
Label: Bearing from Wellington to Parent Site:
Click to expand...
Click to expand...
 
you're welcome, Nikki ;) happy to help

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


Perfect Thanks!


strive4peace said:
Hi Nikki,

instead of using a label, how about using a textbox control

controlSource --> = "Bearing from " & [Daughter Site] & " to Parent Site:"

If this is being done on a form and it is a continuous form, put the
calculation in the underlying recordset...

field --> SiteLabel: "Bearing from " & [Daughter Site] & " to Parent Site:"

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*


Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?

Example:
Record 1
Site Name: Auckland
Label: Bearing from Auckland to Parent Site:

Record 2
Site Name: Wellington
Label: Bearing from Wellington to Parent Site:
Click to expand...
Click to expand...
Click to expand...
 
Nikki said:
Hi,

I have a field called
"Bearing from [Daughter Site] to Parent Site:"

Each record is based on Sites. I would like the report to populate the
[Daughter Site] with the current site name within that label.

Can this be done?
Click to expand...

enter this into a text box..

="Bearing from " & [Daughter Site] & " to Parent Site:"


Regards,
M Woods,
==============
www.fruitchat.co.uk
www.software-illusions.com
 
Back
Top