Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212

    How to format text in a text box or label


    I am designing a form with a few text boxes and much static information. I cannot control the format of text in a text box or label. Not had much luck with a memo field either. Am I missing something obvious?
    Thanks

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    What format do you want?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    The text boxes themselves have a Format Property. You can see this in Design View if you highlight the textbox/label and bring up the Properties. It is on the "Format" tab.

    If you are having problems trying to format something a very particular way, please explain to us the exact format you are trying to apply.

  4. #4
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    when I enter text, I can't use enter or tab, so I am using the control bar to move to the end of a row of text and go to the next row. But the last word of the text moves down a row (for no good reason).

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Are you trying to input multi-line text? Why can't you use enter or tab? Have you considered the EnterKeyBehavior property of textbox? What control bar? I don't understand 'last word of text moves down a row'.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    Enter or tab do not work in a label or text box or a memo field with RTF chosen. When I have tried to get my cursor to the start of a new line, after fiddling with it, the last word of the line moves down to the next line, I do not know why.

  7. #7
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    Hi JoeM,
    Thanks for response. I am just entering text, (which I now understand should be called navigating) Enter of tab do not work, so using the space bar to get to the end of the row to move to next line, after fiddling with arrow keys and anything I can think of to enter the text, the last word of the line I am working on pops itself down on to the next line. I have tried backspace and delete to move the text where I want it to be, but some other hand than mine is moving the text around. very frustrating, must be my ineptness, surely it cannot be Access?????

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Well, label isn't a dynamic control anyway so should be irrelevent. I've never used RTF in my dbs so not really familiar with quirks. Seems like more trouble than it's worth.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    Hi June7,

    How would you add large amounts of static data to a form, (it might look like a government document). With just a few check boxes here and there to be checked off.

    Thanks, appreciate the help.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    No, entering text is not navigating. You must have read my first post before I edited it.

    Are you printing form instead of report?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    I am using the form to collect the check box data, which needs the context of all the static text I am trying to enter.

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    If by 'static' you mean just explanatory info on the form or report and not data in a table somewhere, I just type a very long caption in label control.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  13. #13
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    could I put "carriage return" in a label caption? Would you know?

  14. #14
    Abacus1234 is offline Competent Performer
    Windows Vista Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    212
    I see now that when I think I am typing into some kind of text box, I am really typing into the label control or Control Source of text box. So I can do a lot of single lines, that look like a paragraph. Or go back and try the memo field again. I just don't need to keep all the informational stuff in a database.

  15. #15
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    AFAIK, cannot force CR and LF in label caption. Can just size the control so that text wraps to multiple lines.

    Can force CR and LF in textbox. Example:

    ="test" & Chr(13) & Chr(10) & "test2"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 09-16-2014, 01:55 PM
  2. Replies: 2
    Last Post: 07-09-2014, 06:41 PM
  3. combing two text box values into one label
    By mike02 in forum Access
    Replies: 5
    Last Post: 06-12-2013, 02:47 PM
  4. Replies: 5
    Last Post: 04-24-2013, 08:50 AM
  5. Update Label from Text Box
    By rcdeck in forum Forms
    Replies: 2
    Last Post: 01-30-2013, 11:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums