If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
Slide to left?
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 |
|
Thread Tools | |
Display Modes | |
|
|