Displaying memo fields in datasheet view 1

[billheath]

I have a form with 2 subforms. One of the subforms contains a memo field. When the form displays, and the memo field is longer than the allowed space in the view, there is no way to let the user know that there may be more info in the field than is shown. The user has to go by trial and error. If there is more, he or she can right arrow to see it. If not tested in this way important information goes unnoticed. Is there a way to have the Access denote that there is more than is shown - either direct or through VB code?
Thanks,
Bill Heath

 

[ghubbell]

With your subform in design view, place this code in your memo fields "On Double Click" event by selecting "Event Procedure" and clicking the ellipse "..." to open the Visual Basic Environment (which will label up the procedure for you):

SendKeys "+{F2}", True



Now add this to your memo fields controltip text:
Double-click to zoom!

Close VB and save your form. Give it a try!
Gord
ghubbell@total.net

 

[billheath]

Thanks, Gord. This answers the first half. Second, is there a way to let the reader of the form know that there is information that is not seen. Otherwise, he may not ever go to the field.

 

[ghubbell]

Alright, this one is quite easy and fun:
Place a Label on your Main Form with a caption that says "Notes!"

Add something like this to your main form's "On Current" event:
If IsNull(Forms![NameOfMainForm]![NameOfSubFormAsSeenByTheMainForm].Form![NameOfMemoField]) then
Me![NameOfTheLabelIMade].Visible = False
Else
Me![NameOfTheLabelIMade].Visible = True
End if

I think now I understand your subform is hidden (tab control perhaps)... This will work, and caption the label as you see fit.



Gord
ghubbell@total.net