Scroll bar not showing in a text box on a continuous form

[Mark]

Hi

I'm using Access XP and have a continuos form (which is a subfrom) which
contains three text boxes.

Each text box has its scroll bars property set to vertical yet they don't
show.

I tried using the on enter event to programatically set them using something
like "myControl.scrollbars=2" but still they don't show and the code doesn't
generate any error.

This is a pain as the user doesn't know if there's more text than what's
displayed. I'd like to avoid setting the height of the text box to show an
extra half line so it's obvious as this looks scrappy.

Does anyone know what the cause could be or the solution?

Thanks very much

Mark

 

[Peter Hibbs]

Mark.

It works for me.

Have you set the Left Margin property of the text boxes to anything
other than 0cm, there is a bug in Access that disables the scroll bars
if this property is not 0.

Have you tried using SHIFT + F2 when the text box has the focus to
show a larger text box. Note that I think you have to use CONTROL +
ENTER to move to a new line in this form (even if the Enter Key
Behavior property is set to New Line in Field).

You could also use the Conditional Formatting facility to show if a
text box has more than one line of text by changing the font or back
ground colour of the field if there is a CR character in the text. To
do this set the first field in the Conditonal Formatting form to :-
Expression Is and the second field to :- InStr([Notes],Chr(13))<>0
and set the appropriate back or fore colours as required.

HTH

Peter Hibbs.

 

[Mark]

Hi Peter

The left margin was indeed the problem. I set it back to zero and the
scrolbars are back.

Thanks very much for the reply. Now I have to figure out how to get a margin
without causing the problem. I think text cotrols look terrible without a
gap between the edges and the text.

Thank again

Mark

Mark.

It works for me.

Have you set the Left Margin property of the text boxes to anything
other than 0cm, there is a bug in Access that disables the scroll bars
if this property is not 0.

Have you tried using SHIFT + F2 when the text box has the focus to
show a larger text box. Note that I think you have to use CONTROL +
ENTER to move to a new line in this form (even if the Enter Key
Behavior property is set to New Line in Field).

You could also use the Conditional Formatting facility to show if a
text box has more than one line of text by changing the font or back
ground colour of the field if there is a CR character in the text. To
do this set the first field in the Conditonal Formatting form to :-
Expression Is and the second field to :- InStr([Notes],Chr(13))<>0
and set the appropriate back or fore colours as required.

HTH

Peter Hibbs.

Hi

I'm using Access XP and have a continuos form (which is a subfrom) which
contains three text boxes.

Each text box has its scroll bars property set to vertical yet they don't
show.

I tried using the on enter event to programatically set them using
something
like "myControl.scrollbars=2" but still they don't show and the code
doesn't
generate any error.

This is a pain as the user doesn't know if there's more text than what's
displayed. I'd like to avoid setting the height of the text box to show an
extra half line so it's obvious as this looks scrappy.

Does anyone know what the cause could be or the solution?

Thanks very much

Mark

 

[Peter Hibbs]

Mark.

I agree. I think the only way is to upgrade to Access 2007 as it has
been fixed in this version (I think).

Peter Hibbs.

Hi Peter

The left margin was indeed the problem. I set it back to zero and the
scrolbars are back.

Thanks very much for the reply. Now I have to figure out how to get a margin
without causing the problem. I think text cotrols look terrible without a
gap between the edges and the text.

Thank again

Mark

Mark.

It works for me.

Have you set the Left Margin property of the text boxes to anything
other than 0cm, there is a bug in Access that disables the scroll bars
if this property is not 0.

Have you tried using SHIFT + F2 when the text box has the focus to
show a larger text box. Note that I think you have to use CONTROL +
ENTER to move to a new line in this form (even if the Enter Key
Behavior property is set to New Line in Field).

You could also use the Conditional Formatting facility to show if a
text box has more than one line of text by changing the font or back
ground colour of the field if there is a CR character in the text. To
do this set the first field in the Conditonal Formatting form to :-
Expression Is and the second field to :- InStr([Notes],Chr(13))<>0
and set the appropriate back or fore colours as required.

HTH

Peter Hibbs.

Hi

I'm using Access XP and have a continuos form (which is a subfrom) which
contains three text boxes.

Each text box has its scroll bars property set to vertical yet they don't
show.

I tried using the on enter event to programatically set them using
something
like "myControl.scrollbars=2" but still they don't show and the code
doesn't
generate any error.

This is a pain as the user doesn't know if there's more text than what's
displayed. I'd like to avoid setting the height of the text box to show an
extra half line so it's obvious as this looks scrappy.

Does anyone know what the cause could be or the solution?

Thanks very much

Mark

 

[Mark]

CHeers Peter. Problem is that the client machines are all running Access
XP.

Mark

Mark.

I agree. I think the only way is to upgrade to Access 2007 as it has
been fixed in this version (I think).

Peter Hibbs.

Hi Peter

The left margin was indeed the problem. I set it back to zero and the
scrolbars are back.

Thanks very much for the reply. Now I have to figure out how to get a
margin
without causing the problem. I think text cotrols look terrible without a
gap between the edges and the text.

Thank again

Mark

Mark.

It works for me.

Have you set the Left Margin property of the text boxes to anything
other than 0cm, there is a bug in Access that disables the scroll bars
if this property is not 0.

Have you tried using SHIFT + F2 when the text box has the focus to
show a larger text box. Note that I think you have to use CONTROL +
ENTER to move to a new line in this form (even if the Enter Key
Behavior property is set to New Line in Field).

You could also use the Conditional Formatting facility to show if a
text box has more than one line of text by changing the font or back
ground colour of the field if there is a CR character in the text. To
do this set the first field in the Conditonal Formatting form to :-
Expression Is and the second field to :- InStr([Notes],Chr(13))<>0
and set the appropriate back or fore colours as required.

HTH

Peter Hibbs.




Hi

I'm using Access XP and have a continuos form (which is a subfrom) which
contains three text boxes.

Each text box has its scroll bars property set to vertical yet they
don't
show.

I tried using the on enter event to programatically set them using
something
like "myControl.scrollbars=2" but still they don't show and the code
doesn't
generate any error.

This is a pain as the user doesn't know if there's more text than what's
displayed. I'd like to avoid setting the height of the text box to show
an
extra half line so it's obvious as this looks scrappy.

Does anyone know what the cause could be or the solution?

Thanks very much

Mark