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
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:

&lt;% = Replace(RecordsetName.Fields.Item("FieldName".Value, VbCrLf, "&lt;BR&gt;"%&gt;


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 &gt; Edit &gt; Preferences &gt; 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

Reply to this topic