Slide to left?

Wow!! Thanks so much, and thanks to Mr. Lebans! It saved me so much work
and introduced me to the detail.print event. How handy!!!

"Al Campagna" wrote in message
...
Laurel,
I haven't used this, but Stephan Lebans has an app that should allow
you to mix Bold text and Normal text.
http://www.lebans.com/mixbold-plain.htm
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Laurel" wrote in message
...
My problem there is that the last name has to be bolded, and the first
names not. I don't know how to bold just part of a calculation.

"Al Campagna" wrote in message
...
Laurel,
Have you tried concatenation?
= [LastName] & ", " & [FirstName]
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"Laurel" wrote in message
...
I have three text boxes in the first line of a directory. Their
contents a

!Last_Name =", " =fncFirstNames()

How can I get rid of the white space between !Last_Name and the comma?
All three text boxes have both "Can Shrink" and "Can Grow" set to
"Yes," but that doesn't seem to do the trick.

TIA
LAS

Ah, thanks. Of course I read it, but it didn't sink in that "name of text
box" is not the same as "name in text box."

"Al Campagna" wrote in message
...
Laurel,
Read Duane's previous response...

= Trim(Last_Name) will work... as long as you don't name that control
"Last_Name"

The Name of any calculated field can not match the name of any element
in that calculation.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


"Laurel" wrote in message
...
=[LastName] & ", " & [FirstName]

I took this as the control source from a report in one of the databases
Al Campagna recommended. Why does this work, but trim([Last_Name]) in my
case, doesn't? You can concatenate fields but you can't act on them with
functions? What's the rule?

"Duane Hookom" wrote in message
...
I expect the name of your text box is the name of a field. This would
cause
an error.

This solution won't work anyway based on your requirements. A text box
will
not shrink horizontally, only vertically.

--
Duane Hookom
Microsoft Access MVP


"Laurel" wrote:

Well, I was certainly hoping that this approach would work, being the
simplest, but when I put the function on I get #Error instead of the
last
name in all rows. The following was cut from the control source and
pasted
here. I created it by choosing the function and then choosing the
field.
In other words, no typos. What am I doing wrong?

=Trim([Last_Name])

"Darrell Childress" wrote in message
...
What about =Trim([LastName]) This will remove any leading or ending
spaces.

Laurel wrote:
My problem there is that the last name has to be bolded, and the
first
names not. I don't know how to bold just part of a calculation.

"Al Campagna" wrote in message
...
Laurel,
Have you tried concatenation?
= [LastName] & ", " & [FirstName]
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"Laurel" wrote in message
...
I have three text boxes in the first line of a directory. Their
contents a

!Last_Name =", " =fncFirstNames()

How can I get rid of the white space between !Last_Name and the
comma?
All three text boxes have both "Can Shrink" and "Can Grow" set to
"Yes," but that doesn't seem to do the trick.

TIA
LAS