[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

Access 2002. Form. Field level. Word Wrap functionality.

Access 2002.  Form Text Fields.  Do the text fields have Word Wrap or the like ?  If so, how is it turned on ?

Thank you.
0
ellenjbr
Asked:
ellenjbr
  • 3
  • 3
  • 3
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
< Do the text fields have Word Wrap> No.

enable vertical scroll bar in the Format property

scroll bar  Vertical
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
On you text box control Property Sheet ... 'Other' Tab ... Set the 'Enter Key Behavior' property to 'New Line in Field' ... this will allow you to enter carriage returns and line feeds, create new paragraphs, etc.

mx

0
 
ellenjbrAuthor Commented:
I wanted a word wrap function for when I have a read only record that I do not want any value altered.

I did not want to have to add code to each field to not allow for the value to change.  Any simple suggestions ?  Thank you.
0
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Sorry ... not quite following your question?

You have two choices in a Text box ... what Cap said and what I posted. No code is required in either case

mx
0
 
Rey Obrero (Capricorn1)Commented:
ellenjbr,

<I do not want any value altered.>
can you be more specific about what value you don't want altered?
0
 
ellenjbrAuthor Commented:
The value that resides in each respective field, when it is not a blank value.  Some persons only have a 'read only' ability for any field on the form.  However, due to space constraints and so forth ... I use a scroll bar for the user to scroll through a field with potentially long text.  They cannot use it when I have:  fieldname1.enabled = false AND fieldname1.locked = true

Thank you.
0
 
Rey Obrero (Capricorn1)Commented:
just set the field

fieldname1.enabled = True AND fieldname1.locked = true

they cannot change the data but they can scroll using the vertical scroll bar
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Why not just lock it and not disable it?  That way, the user can click into the field.

mx
0
 
ellenjbrAuthor Commented:
That works.  Thank you.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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