Descriptions cut short in report
in [Getting Started]
|
From: Andrew Hollis on 26 Jun 2008 14:39 I have a report that has a "description" text parameter with sometimes lengthy descriptions which are being cut off. Is there a way to force it to show the entire description regardles of length? I thought it would be in the format tab of the description properties, but the only thing I can see that might do it is a "can grow" option which is already set to "yes."
From: Douglas J. Steele on 26 Jun 2008 18:55 If you're sorting on the description field, it's going to be treated as a text field, which means it's limited to 255 characters. As well, if you're applying any formatting to the description, the same will happen. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Andrew Hollis" <AndrewHollis(a)discussions.microsoft.com> wrote in message news:6499CCBE-3F54-4D07-A32E-EBAEEEB06F1C(a)microsoft.com... >I have a report that has a "description" text parameter with sometimes > lengthy descriptions which are being cut off. Is there a way to force it > to > show the entire description regardles of length? I thought it would be in > the format tab of the description properties, but the only thing I can see > that might do it is a "can grow" option which is already set to "yes."
From: Ken Sheridan on 27 Jun 2008 19:11 This can also (sometimes but not invariably) happen if a memo field has been added to a report by dragging from the field list or the report has been created with the report wizard. If so, delete the control from the report, add a text box and set its ControlSource property to the name of the memo field. It can also happen with forms and, in my experience, even in datasheet view of a table if the data has been imported. I first encountered it many years ago with data imported from dBASE. BTW, if you do bind a text box in a form to a memo field you may want to change its EnterKeyBehaviour property to 'Next line in field', which is the default if a memo field added by dragging from the field list or by the form wizard, but not otherwise. Ken Sheridan Stafford, England "Andrew Hollis" wrote: > I have a report that has a "description" text parameter with sometimes > lengthy descriptions which are being cut off. Is there a way to force it to > show the entire description regardles of length? I thought it would be in > the format tab of the description properties, but the only thing I can see > that might do it is a "can grow" option which is already set to "yes."
From: Andrew Hollis on 30 Jun 2008 08:55 Okay, I deleted the Description field from the report and inserted a text box with the ControlSource property set to the memo field (description), but am still having the same outcome. I checked that its not sorted and no formatting is in effect either. Are there any other work-arounds that might do the trick? "Ken Sheridan" wrote: > This can also (sometimes but not invariably) happen if a memo field has been > added to a report by dragging from the field list or the report has been > created with the report wizard. If so, delete the control from the report, > add a text box and set its ControlSource property to the name of the memo > field. > > It can also happen with forms and, in my experience, even in datasheet view > of a table if the data has been imported. I first encountered it many years > ago with data imported from dBASE. > > BTW, if you do bind a text box in a form to a memo field you may want to > change its EnterKeyBehaviour property to 'Next line in field', which is the > default if a memo field added by dragging from the field list or by the form > wizard, but not otherwise. > > Ken Sheridan > Stafford, England > > "Andrew Hollis" wrote: > > > I have a report that has a "description" text parameter with sometimes > > lengthy descriptions which are being cut off. Is there a way to force it to > > show the entire description regardles of length? I thought it would be in > > the format tab of the description properties, but the only thing I can see > > that might do it is a "can grow" option which is already set to "yes." >
From: Ken Sheridan on 30 Jun 2008 13:50
The following also works for me, but then so does the approach I first suggested, so it might not necessarily work for you: 1. Add an unbound control named txtDescription. 2. Set the ControlSource property of the control to =[Description]. Ken Sheridan Stafford, England "Andrew Hollis" wrote: > Okay, I deleted the Description field from the report and inserted a text box > with the ControlSource property set to the memo field (description), but am > still having the same outcome. > I checked that its not sorted and no formatting is in effect either. Are > there any other work-arounds that might do the trick? > > "Ken Sheridan" wrote: > > > This can also (sometimes but not invariably) happen if a memo field has been > > added to a report by dragging from the field list or the report has been > > created with the report wizard. If so, delete the control from the report, > > add a text box and set its ControlSource property to the name of the memo > > field. > > > > It can also happen with forms and, in my experience, even in datasheet view > > of a table if the data has been imported. I first encountered it many years > > ago with data imported from dBASE. > > > > BTW, if you do bind a text box in a form to a memo field you may want to > > change its EnterKeyBehaviour property to 'Next line in field', which is the > > default if a memo field added by dragging from the field list or by the form > > wizard, but not otherwise. > > > > Ken Sheridan > > Stafford, England > > > > "Andrew Hollis" wrote: > > > > > I have a report that has a "description" text parameter with sometimes > > > lengthy descriptions which are being cut off. Is there a way to force it to > > > show the entire description regardles of length? I thought it would be in > > > the format tab of the description properties, but the only thing I can see > > > that might do it is a "can grow" option which is already set to "yes." > > |