Forums
This topic is locked
Form data stretching table & td
Posted 09 Jan 2002 08:14:32
1
has voted
09 Jan 2002 08:14:32 John Gough posted:
I feel stupid but I am at a total loss..after Updating or Inserting to an rs the table/td where the rs element is placed is not wrapping but simply growing wider despite their widths being set. This does NOT occr when I cut and paste from a Word DOC to the form field. Your assistance is greatly appreciated.Replies
Replied 09 Jan 2002 08:31:58
09 Jan 2002 08:31:58 Owen Eastwick replied:
Do you mean that when displaying text fom a memo field in the database that the New line formatting is lost?
In which case display the memo field on the page like this:
<% = Replace(RecordsetName.Fields.Item("FieldName".Value, VbCrLf, "<BR>"%>
Or do you mean that the Dynamic Text is too wide when you drag it into a table cell on the page while working in design view?
In which case go to the Site window > Edit > Preferences > Invisible Elements then at the bottom change Show Dynamic Text As: From this {Recordset.Field} to this {}. All dynamic text on in design view will be shown as just a pair of curly brackets, instead of a long Recordset value which screws up your table widths.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
In which case display the memo field on the page like this:
<% = Replace(RecordsetName.Fields.Item("FieldName".Value, VbCrLf, "<BR>"%>
Or do you mean that the Dynamic Text is too wide when you drag it into a table cell on the page while working in design view?
In which case go to the Site window > Edit > Preferences > Invisible Elements then at the bottom change Show Dynamic Text As: From this {Recordset.Field} to this {}. All dynamic text on in design view will be shown as just a pair of curly brackets, instead of a long Recordset value which screws up your table widths.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 09 Jan 2002 12:54:04
09 Jan 2002 12:54:04 John Gough replied:
Although I don't understand Vb to the degree needed your Replace looked like the fix I needed but did nothing to save my table/td widths. I think you understand my problem, yes when typing multi-line text into an Insert or Update form to Access 2000 the UD recordset field, we'll call it "memo1", simply continues east ...forever, without wrapping...still
Thanks
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Do you mean that when displaying text fom a memo field in the database that the New line formatting is lost?
In which case display the memo field on the page like this:
<% = Replace(RecordsetName.Fields.Item("FieldName".Value, VbCrLf, "<BR>"%>
Or do you mean that the Dynamic Text is too wide when you drag it into a table cell on the page while working in design view?
In which case go to the Site window > Edit > Preferences > Invisible Elements then at the bottom change Show Dynamic Text As: From this {Recordset.Field} to this {}. All dynamic text on in design view will be shown as just a pair of curly brackets, instead of a long Recordset value which screws up your table widths.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Thanks
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Do you mean that when displaying text fom a memo field in the database that the New line formatting is lost?
In which case display the memo field on the page like this:
<% = Replace(RecordsetName.Fields.Item("FieldName".Value, VbCrLf, "<BR>"%>
Or do you mean that the Dynamic Text is too wide when you drag it into a table cell on the page while working in design view?
In which case go to the Site window > Edit > Preferences > Invisible Elements then at the bottom change Show Dynamic Text As: From this {Recordset.Field} to this {}. All dynamic text on in design view will be shown as just a pair of curly brackets, instead of a long Recordset value which screws up your table widths.
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Replied 17 Jan 2002 13:58:37
17 Jan 2002 13:58:37 John Gough replied:
Sorry everyone...turned out to be a real simple one...thanks to you who helped...in my testing I was typing continuously in the form/memo field. The simple addition of one space character allowed the table boundaries to work