need help for memo field!!!

  • Thread starter Thread starter leigh
  • Start date Start date
L

leigh

I have a form that users can access in a read-only state.
Some of the information on the form have values that are
longer than the width of the bound control on the form.
Is there a way I can display the complete text without
requiring the user to click in the field and using arrow
keys to read the value? How can I display the complete
text where users can just move their mouse over the field
and it will show the complete text... the fields I want
to display is in MEMO type so its impossible to use
controltips. I will really appreciate any help!!! thanks
in advance!!!
 
Just a thought...
If your users are only looking at the form, you could
do the following:
1. Set the memo field property CanGrow to "Yes"
2. View the form in Print Preview mode. CanGrow kicks
in in print preview to open up the field as much as needed
to display the whole content, but not in simple form
view. You could help your unknowledgeable users by adding
a Print Preview button to the form with a label saying
something like "to view complete contents, click here".

Hope this helps.
 
Two possible solutions:

1) Add a Header section to your Form containing an unbound TextBox
control large enough to display the Memo field. Use the following
solution to update the TextBox in the Header as the user moves their
mouse over the bound TextBox control.
http://www.lebans.com/conformscurcontrol.htm
ContinuousFormsCurrentRow.zip is a class that allows you to
programmatically access the contents of a bound control, as the user
moves their Mouse, but the control does not have the focus. For Forms in
Continuous View.

2) You can use Tooltips. The ToolTips class on my site supports multiple
lines of Text. See:
http://www.lebans.com/tooltip.htm
ToolTip.zip is a database containing a custom ToolTip class for use in
A97 or higher.

A2KToolTip.zip is a database containing both an API and Form based
ToolTip solutions. The Form based solution can be used for forms in
DataSheet view.

Enhanced features include:

Selectable delay times for Toolltip to first appear
Selectable delay times for Tooltip to dissappear
Selectable Text Color
Selectable Background Color
Selectable Margins
Specify Tooltip size
Add a title to the Tooltip in Bold
Selectable Icon for the Tooltip
ToolTips for Lines, Boxes, any rectangular area on your Form

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top