wrap text

Wondering if there's any way I can use the "Wrap Text" feature just like in
excel for the Memo field in Access form? I have an "Employee List" form with
one of the the field as "Comments" which I've set as "memo" data type. It's
in datasheet format. Some comments are long and have to scroll all the way
to read thru to the end of the comment.

Thanks, Bob

On Jan 11, 8:33*pm, Bob76 wrote:
Wondering if there's any way I can use the "Wrap Text" feature just like in
excel for the Memo field in Access form? *I have an "Employee List" form with
one of the the field as "Comments" which I've set as "memo" data type. It's
in datasheet format. *Some comments are long and have to scroll all the way
to read thru to the end of the comment. *

Thanks, Bob

ouch. don't use datasheets for memos. then you can set the scrolling
in the control on your form.

Hi Bob,

In the left margin, position your cursor over the dividing line between
a couple of records. When it turns into a line with an up arrow above it and
a down arrow below it click and drag down until you get a larger size row.
You won't get scroll bars, but it will wrap and will allow you to move up and
down with the arrows or by clicking withing the field and dragging up or
down. However it is probably better to shift to a continuous form. Then the
scroll bars will show.

Clifford Bass

"Bob76" wrote:

Wondering if there's any way I can use the "Wrap Text" feature just like in
excel for the Memo field in Access form? I have an "Employee List" form with
one of the the field as "Comments" which I've set as "memo" data type. It's
in datasheet format. Some comments are long and have to scroll all the way
to read thru to the end of the comment.

Thanks, Bob

Hi Clifford,
Thank you, thank you...Followed your instructions and I did it! I spent
several hours today trying to find out how to do it, from books and
trial/error and got so frustrated bec nowhere does it tell you how it's done.
Just started learning Access07 4 months ago, from books & online but I've
learned ways & tricks from this discussion group that are not mentioned in
any Access books at all. Hurrah!!!

By the way, what do you mean by "continuous form"?
Thanks, Bob

"Clifford Bass" wrote:

Hi Bob,

In the left margin, position your cursor over the dividing line between
a couple of records. When it turns into a line with an up arrow above it and
a down arrow below it click and drag down until you get a larger size row.
You won't get scroll bars, but it will wrap and will allow you to move up and
down with the arrows or by clicking withing the field and dragging up or
down. However it is probably better to shift to a continuous form. Then the
scroll bars will show.

Clifford Bass

"Bob76" wrote:

Wondering if there's any way I can use the "Wrap Text" feature just like in
excel for the Memo field in Access form? I have an "Employee List" form with
one of the the field as "Comments" which I've set as "memo" data type. It's
in datasheet format. Some comments are long and have to scroll all the way
to read thru to the end of the comment.

Thanks, Bob

Hi Bob,

A lot of it is learning by the seat of your pants. Most of the stuff
(books, whatnot) gets you started but can never cover all the convolutions of
what people want to do.

A continuous form is one that takes a single form and repeats it
continuously down the screen, with a scroll bar on the right side of the form
if/as needed. To do that, design your form as a single form and in the
form's properties make sure Allow Form View is set to Yes and change the
Default view to Continuous Forms.

Clifford Bass

"Bob76" wrote:

Hi Clifford,
Thank you, thank you...Followed your instructions and I did it! I spent
several hours today trying to find out how to do it, from books and
trial/error and got so frustrated bec nowhere does it tell you how it's done.
Just started learning Access07 4 months ago, from books & online but I've
learned ways & tricks from this discussion group that are not mentioned in
any Access books at all. Hurrah!!!

By the way, what do you mean by "continuous form"?
Thanks, Bob

Hi Clifford,
Thanks for your very helpful tips...

Bob

"Clifford Bass" wrote:

Hi Bob,

A lot of it is learning by the seat of your pants. Most of the stuff
(books, whatnot) gets you started but can never cover all the convolutions of
what people want to do.

A continuous form is one that takes a single form and repeats it
continuously down the screen, with a scroll bar on the right side of the form
if/as needed. To do that, design your form as a single form and in the
form's properties make sure Allow Form View is set to Yes and change the
Default view to Continuous Forms.

Clifford Bass

"Bob76" wrote:

Hi Clifford,
Thank you, thank you...Followed your instructions and I did it! I spent
several hours today trying to find out how to do it, from books and
trial/error and got so frustrated bec nowhere does it tell you how it's done.
Just started learning Access07 4 months ago, from books & online but I've
learned ways & tricks from this discussion group that are not mentioned in
any Access books at all. Hurrah!!!

By the way, what do you mean by "continuous form"?
Thanks, Bob

Hi Bob,

You are welcome.

Clifford Bass

"Bob76" wrote:

Hi Clifford,
Thanks for your very helpful tips...

Bob