Results 1 to 4 of 4
  1. #1
    Jen0dorf is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453

    text box formatting

    Hi



    not sure how to phrase this but

    I have a text box which is populated via a control source of

    Code:
    ="WSM FHS " & [TempVars]![varPlace] & " Parish Records"
    where the variable is drawn from a a table listing Parish names. This I have used on the 20 forms used in a parish. The idea is that I can just change the variable value when I change Parish and avoid changing every form!

    It works perfectly and does exactly what I want.

    However when I view the form if I click on the text box by accident it turns white and a curser appears although you cannot type into the box.

    No doubt it is a setting in the field properties but I can't see it.

    thanks

    Ian

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,742
    Try setting the textbox property LOCKED=Yes. You can do it from the property view data tab.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Also, the ENABLED property should be set to NO

  4. #4
    Jen0dorf is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    UK
    Posts
    453
    HI

    thanks both - solved so simple like all things when you know
    Ian

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-30-2015, 08:50 AM
  2. Formatting text of an export
    By Sarge, USMC in forum Import/Export Data
    Replies: 11
    Last Post: 02-27-2013, 09:08 PM
  3. Replies: 3
    Last Post: 02-07-2013, 09:53 PM
  4. Unbound Text Box Formatting
    By Pam Buckner in forum Forms
    Replies: 2
    Last Post: 10-14-2011, 01:31 PM
  5. Text Formatting
    By BLD21 in forum Access
    Replies: 4
    Last Post: 07-22-2011, 08:25 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