• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 529
  • Last Modified:

Can the scroll bar on a memo field be displayed without having to click within the memo field's text box?

I have a memo field within an Access 2007 table, Field A, which is on a continuous form. Within the Properties window, Scroll Bars is set to Vertical. The scroll bar only appear when I click within Field A. Is there a way to have the scroll bar automatically appear when the text within the field exceeds the size of its text box on the form? Otherwise, the user may not realize that there is additional text within the field that they are not seeing.

I am looking for a way to alert the user to scroll downwards to see additional important text without having to increase the size of the text box.

thanks.
0
newbie46
Asked:
newbie46
  • 2
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
There is no property setting to do this.

mx
0
 
newbie46Author Commented:
OK. thanks.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I was thinking that maybe, using Conditional Formatting, you could test the  Len() the text ... using a length that you know ... would cause a scroll bar, then set the backcolor to something different, to indicate 'more ..."

mx
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now