Text box and "=" values

[LSSR]

Q1- I have label with control source =Count(*) & " " & ("Records") and it
works fine. I need to have the text placed in front of the =, i.e., to print
as Total records: XX. I have not been able to find a way to place text in
front of the =.

Q2- Is there a way to place two = functions in the same text box?
I have =Trim("City of " & [CITY] & " " & "(XXXXXXXX) XXX") and it works
fine. The powers that be want this string to include the record count and
the end of the string.

I dont know VBA. Thanks for your help.

 

[Jeff Boyce]

A1 ="Total records: " & Count(*)

A2 I have no idea what you mean by "(XXXXXXXXX) XXX" -- what is
"the end of the string"?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[LSSR]

Thank you, A1 works perfect. Re: Q2,
=Trim("City of " & [CITY] & " " & "(Sorted by address) All listings")

Your response to Q1 gave me a clue to Q2 and I got it. Thanks much for your
help. Have a blessed New Year.

A1 ="Total records: " & Count(*)

A2 I have no idea what you mean by "(XXXXXXXXX) XXX" -- what is
"the end of the string"?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Q1- I have label with control source =Count(*) & " " & ("Records") and it
works fine. I need to have the text placed in front of the =, i.e., to print
as Total records: XX. I have not been able to find a way to place text in
front of the =.

Q2- Is there a way to place two = functions in the same text box?
I have =Trim("City of " & [CITY] & " " & "(XXXXXXXX) XXX") and it works
fine. The powers that be want this string to include the record count and
the end of the string.

I dont know VBA. Thanks for your help.