Textbox - Wrap text onto second line for long fields
in [Reports]
|
Prev: Count detail only if it's different than other details in a group
Next: Reporting Out Two Names w/Phone # from the Same Table
From: Paul Kraemer on 30 Jun 2008 15:44 Hi, I have a (Access 2000) report that has a textbox in the group footer section. I have a formula in this textbox that concatenates two string fields. Sometimes (but not very often), the length of these two string fields is long enough that the concatenated text does not completely fit in the text box. In these cases, I was wondering if I could automatically increase the height of the textbox and have the text wrap onto a second line. I tried setting the "Can Grow" property to yes for both the text box and the group footer section, but doing this did not help. Any help will be greatly appreciated. Thanks in advance, Paul -- Paul Kraemer
From: Jeff Boyce on 30 Jun 2008 19:10 Paul If there are any objects directly aligned and to the right, they constrain the ability of your textbox to Grow/Shrink. You'll also want to set the CanShrink to 'yes', as you (probably) want that textbox to close back up if it doesn't need the extra room. Regards Jeff Boyce Microsoft Office/Access MVP "Paul Kraemer" <PaulKraemer(a)discussions.microsoft.com> wrote in message news:42193D2D-105F-4E37-A614-E8B325350B0C(a)microsoft.com... > Hi, > > I have a (Access 2000) report that has a textbox in the group footer > section. I have a formula in this textbox that concatenates two string > fields. Sometimes (but not very often), the length of these two string > fields is long enough that the concatenated text does not completely fit > in > the text box. In these cases, I was wondering if I could automatically > increase the height of the textbox and have the text wrap onto a second > line. > I tried setting the "Can Grow" property to yes for both the text box and > the > group footer section, but doing this did not help. > > Any help will be greatly appreciated. > > Thanks in advance, > Paul > -- > Paul Kraemer
From: Paul Kraemer on 1 Jul 2008 08:26 Hi Jeff, I do have two other textboxes to the right of (and top aligned with) the textbox that I want to be able to grow. These other textboxes will never contain enough text to *need* a second line, but if I set Can Grow/Can Shrink = Yes for these textboxes, will they follow along with the other textbox that will actually need to grow/shrink at times? Thank you for your help, Paul -- Paul Kraemer "Jeff Boyce" wrote: > Paul > > If there are any objects directly aligned and to the right, they constrain > the ability of your textbox to Grow/Shrink. You'll also want to set the > CanShrink to 'yes', as you (probably) want that textbox to close back up if > it doesn't need the extra room. > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > > "Paul Kraemer" <PaulKraemer(a)discussions.microsoft.com> wrote in message > news:42193D2D-105F-4E37-A614-E8B325350B0C(a)microsoft.com... > > Hi, > > > > I have a (Access 2000) report that has a textbox in the group footer > > section. I have a formula in this textbox that concatenates two string > > fields. Sometimes (but not very often), the length of these two string > > fields is long enough that the concatenated text does not completely fit > > in > > the text box. In these cases, I was wondering if I could automatically > > increase the height of the textbox and have the text wrap onto a second > > line. > > I tried setting the "Can Grow" property to yes for both the text box and > > the > > group footer section, but doing this did not help. > > > > Any help will be greatly appreciated. > > > > Thanks in advance, > > Paul > > -- > > Paul Kraemer > > >
From: Jeff Boyce on 1 Jul 2008 12:40
Paul I'm not sure ... check it out and post back! Or another approach would be to 'nudge' your Grow/Shrink textbox slightly higher (i.e., don't keep their tops aligned). Regards Jeff Boyce Microsoft Office/Access MVP "Paul Kraemer" <PaulKraemer(a)discussions.microsoft.com> wrote in message news:3EE92891-4A2E-455D-9A9C-04E856032B2A(a)microsoft.com... > Hi Jeff, > > I do have two other textboxes to the right of (and top aligned with) the > textbox that I want to be able to grow. These other textboxes will never > contain enough text to *need* a second line, but if I set Can Grow/Can > Shrink > = Yes for these textboxes, will they follow along with the other textbox > that > will actually need to grow/shrink at times? > > Thank you for your help, > Paul > > -- > Paul Kraemer > > > "Jeff Boyce" wrote: > >> Paul >> >> If there are any objects directly aligned and to the right, they >> constrain >> the ability of your textbox to Grow/Shrink. You'll also want to set the >> CanShrink to 'yes', as you (probably) want that textbox to close back up >> if >> it doesn't need the extra room. >> >> Regards >> >> Jeff Boyce >> Microsoft Office/Access MVP >> >> >> "Paul Kraemer" <PaulKraemer(a)discussions.microsoft.com> wrote in message >> news:42193D2D-105F-4E37-A614-E8B325350B0C(a)microsoft.com... >> > Hi, >> > >> > I have a (Access 2000) report that has a textbox in the group footer >> > section. I have a formula in this textbox that concatenates two string >> > fields. Sometimes (but not very often), the length of these two string >> > fields is long enough that the concatenated text does not completely >> > fit >> > in >> > the text box. In these cases, I was wondering if I could automatically >> > increase the height of the textbox and have the text wrap onto a second >> > line. >> > I tried setting the "Can Grow" property to yes for both the text box >> > and >> > the >> > group footer section, but doing this did not help. >> > >> > Any help will be greatly appreciated. >> > >> > Thanks in advance, >> > Paul >> > -- >> > Paul Kraemer >> >> >> |