Auto expand memo field in continuous form

[Margretta]

I found (to my delight) and worked with Stephan Lebans module/solution
textwidth-height to automatically expand a memo field on a form. It
works perfectly if the form is set to Single Form, but doesn't function
well in a continuous form environment. In continuous form mode, the
solution only recognizes either the first recordset or the recordset
that has focus.

Is there a way to modify the code so that it recognizes the individual
recordsets on a continuous form?

I'm fairly new to all of this, but loving it. Thanks in advance for
anyone's advice and suggestions.

Thanks,
Margretta

 

[missinglinq via AccessMonster.com]

This will zoom the memo box on a continuous form if it has data in it:

Private Sub YourMemoControl_GotFocus()
If Not IsNull(Me.YourMemoControl.Value) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

If you want the memo box to zoom for data entry as well omit the bold lines.

 

[missinglinq via AccessMonster.com]

Sorry, forgot yuou can't use bold tags on this forum! Omit lines:

If Not IsNull(Me.YourMemoControl.Value) Then

and

End If

If you want the memo box to zoom for data entry as well.

This will zoom the memo box on a continuous form if it has data in it:

Private Sub YourMemoControl_GotFocus()
If Not IsNull(Me.YourMemoControl.Value) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

If you want the memo box to zoom for data entry as well omit the bold lines.

I found (to my delight) and worked with Stephan Lebans module/solution
textwidth-height to automatically expand a memo field on a form. It

[quoted text clipped - 11 lines]

Thanks,
Margretta

 

[Margretta]

I love the pop up box. This way was MUCH simpler than the additional
form querying the existing form option that I had created. Thank you!

I'm wondering though if there is a way to have the text box/memo field
display all the data on the main form without having to have a pop up
box.

I'm trying to account for situations where users won't go the extra
step to scroll down in a text box or even notice that they can click on
it to get the pop up box. Stephan Lebans option works great for
expanding the box, but it only expands either the first box in the
group or text box that has focus.

Any thoughts?

Thanks,
Margretta

Sorry, forgot yuou can't use bold tags on this forum! Omit lines:

If Not IsNull(Me.YourMemoControl.Value) Then

and

End If

If you want the memo box to zoom for data entry as well.

This will zoom the memo box on a continuous form if it has data in it:

Private Sub YourMemoControl_GotFocus()
If Not IsNull(Me.YourMemoControl.Value) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

If you want the memo box to zoom for data entry as well omit the bold lines.

I found (to my delight) and worked with Stephan Lebans module/solution
textwidth-height to automatically expand a memo field on a form. It

[quoted text clipped - 11 lines]

Thanks,
Margretta

 

[Margretta]

I think I may have screwed up my last posting so it wasn't obvious that
I was still looking for some help on the problem of auto expanding a
field on screen to display all data for a given record.

Stephan Lebans solution works great for single forms, but isn't suited
for continuous forms. Any thoughts?

Thanks,
Margretta

I love the pop up box. This way was MUCH simpler than the additional
form querying the existing form option that I had created. Thank you!

I'm wondering though if there is a way to have the text box/memo field
display all the data on the main form without having to have a pop up
box.

I'm trying to account for situations where users won't go the extra
step to scroll down in a text box or even notice that they can click on
it to get the pop up box. Stephan Lebans option works great for
expanding the box, but it only expands either the first box in the
group or text box that has focus.

Any thoughts?

Thanks,
Margretta

Sorry, forgot yuou can't use bold tags on this forum! Omit lines:

If Not IsNull(Me.YourMemoControl.Value) Then

and

End If

If you want the memo box to zoom for data entry as well.

This will zoom the memo box on a continuous form if it has data in it:

Private Sub YourMemoControl_GotFocus()
If Not IsNull(Me.YourMemoControl.Value) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

If you want the memo box to zoom for data entry as well omit the bold lines.

I found (to my delight) and worked with Stephan Lebans module/solution
textwidth-height to automatically expand a memo field on a form. It
[quoted text clipped - 11 lines]
Thanks,
Margretta

 

[marius]

Try this http://www.mvp-access.com/marius/ejemplos/awforms.zip , look for
"Tamaño Memo" option and hit max/auto.

--
HTH,
Màrius - http://www.mvp-access.com/foro/default.asp

I think I may have screwed up my last posting so it wasn't obvious that
I was still looking for some help on the problem of auto expanding a
field on screen to display all data for a given record.

Stephan Lebans solution works great for single forms, but isn't suited
for continuous forms. Any thoughts?

Thanks,
Margretta

I love the pop up box. This way was MUCH simpler than the additional
form querying the existing form option that I had created. Thank you!

I'm wondering though if there is a way to have the text box/memo field
display all the data on the main form without having to have a pop up
box.

I'm trying to account for situations where users won't go the extra
step to scroll down in a text box or even notice that they can click on
it to get the pop up box. Stephan Lebans option works great for
expanding the box, but it only expands either the first box in the
group or text box that has focus.

Any thoughts?

Thanks,
Margretta

Sorry, forgot yuou can't use bold tags on this forum! Omit lines:

If Not IsNull(Me.YourMemoControl.Value) Then

and

End If

If you want the memo box to zoom for data entry as well.


missinglinq wrote:
This will zoom the memo box on a continuous form if it has data in it:

Private Sub YourMemoControl_GotFocus()
If Not IsNull(Me.YourMemoControl.Value) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

If you want the memo box to zoom for data entry as well omit the bold lines.

I found (to my delight) and worked with Stephan Lebans module/solution
textwidth-height to automatically expand a memo field on a form. It
[quoted text clipped - 11 lines]
Thanks,
Margretta

 

[Margretta]

Sorry to have been silent for so long.

Thank you! This is working great now!

Thanks,
Margretta

Try this http://www.mvp-access.com/marius/ejemplos/awforms.zip , look for
"Tamaño Memo" option and hit max/auto.

--
HTH,
Màrius - http://www.mvp-access.com/foro/default.asp

I think I may have screwed up my last posting so it wasn't obvious that
I was still looking for some help on the problem of auto expanding a
field on screen to display all data for a given record.

Stephan Lebans solution works great for single forms, but isn't suited
for continuous forms. Any thoughts?

Thanks,
Margretta

I love the pop up box. This way was MUCH simpler than the additional
form querying the existing form option that I had created. Thank you!

I'm wondering though if there is a way to have the text box/memo field
display all the data on the main form without having to have a pop up
box.

I'm trying to account for situations where users won't go the extra
step to scroll down in a text box or even notice that they can click on
it to get the pop up box. Stephan Lebans option works great for
expanding the box, but it only expands either the first box in the
group or text box that has focus.

Any thoughts?

Thanks,
Margretta



missinglinq via AccessMonster.com wrote:
Sorry, forgot yuou can't use bold tags on this forum! Omit lines:

If Not IsNull(Me.YourMemoControl.Value) Then

and

End If

If you want the memo box to zoom for data entry as well.


missinglinq wrote:
This will zoom the memo box on a continuous form if it has data in it:

Private Sub YourMemoControl_GotFocus()
If Not IsNull(Me.YourMemoControl.Value) Then
DoCmd.RunCommand acCmdZoomBox
End If
End Sub

If you want the memo box to zoom for data entry as well omit the bold lines.

I found (to my delight) and worked with Stephan Lebans module/solution
textwidth-height to automatically expand a memo field on a form. It
[quoted text clipped - 11 lines]
Thanks,
Margretta