help pls

D

Dean Cowlishaw

Hi

Created a subform in my main form and it links to a a seperate table,
basically storing notes. The problem is the form shows the notes feild as
one continuous cell, how do i define the length of text within the cell to
force it to a new line, instead of a continuous stream...

Hope this makes sense

Dean
 
R

Rick B

If you want notes separated into separate "cells" (which is an Excel term)
then you would need to add a separate record for each note. Then, your
subform would contain several different records, each on a separate line of
your subform.
 
D

Dean Cowlishaw

Sorry maybe im not being clear....

Basically when i enter text lets say into a feild called 'note' within a
subform its one continuous line and does not go to next line when hits end of
box.

Ive obvioulsy missed something, but cant for what figure it out?

Any ideas

dean
 
R

Rick B

If the subform is listing items in a continuous datasheet view, then you are
correct. There will be no word-wrap.
 
J

John Vinson

Sorry maybe im not being clear....

Basically when i enter text lets say into a feild called 'note' within a
subform its one continuous line and does not go to next line when hits end of
box.

Ive obvioulsy missed something, but cant for what figure it out?
Click to expand...

If you use a Continuous Form rather than a datasheet, text *will* word
wrap in a Textbox. It won't actually be stored with newline
characters, but it will also wordwrap to fit a textbox on a Report
(even if the textbox is of a different size).

The problem is one of the many limitations of using Datasheets.

John W. Vinson[MVP]
 
Top