Results 1 to 7 of 7
  1. #1
    tfmurphhk is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    5

    Deleted field names in forms

    I inadvertently deleted the field name when I was creating a form. I have the field showing, but not the name of that field.

    For example I inserted a field named Property Address.. but when I view the form, the field is there, but no naming.. maybe what I am referring to is the caption? Not sure.

    Anyway, how do I restore those names without having to delete the field and then reinsert it into the form WITH the field caption?



    Thanks for any assistance in correcting my stupid error.

    Tom

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    Do you mean a label?

    Select label control from design tab on ribbon and add to form. Put whatever text you want into the label. This will be an unassociated label. Then if you want, associate it with existing textbox.

    One you first install a label on form, it will have a little red triangle in corner. Click it, this will expose a dropdown button, click that and menu will appear, select "Associate" option, pick textbox.

    Or just delete and recreate textbox with its associated label.
    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
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    Then if you want, associate it with existing textbox.
    After creating the new label, select it, cut it (ctrl+x) then select the control (textbox?) and paste (ctrl+v)
    It should then be attached as it was before.

    Next time if you delete a form control by mistake and notice right away, try ctrl+z to undo.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    tfmurphhk is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    5
    Quote Originally Posted by Micron View Post
    After creating the new label, select it, cut it (ctrl+x) then select the control (textbox?) and paste (ctrl+v)
    It should then be attached as it was before.
    Thank you. Your reply, combined with the previous one, got me back on track.

    I am not new to Access... but surely still very much a Noob.

    If I may, another question. Is there a way to have the label actually show up INSIDE of the textbox when in form view?

    Thank you so much

    Tom

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    Over, yes. Inside, no. Location is primarily determined in design or layout view. Why would you want to obscure the textbox with a label?

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    You want textbox to have some text inside it such as seen on many web input boxes, like: [Enter Name] ?

    DefaultValue property can display something but this should be something you would want saved if user does not change it.
    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.

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    alternative for showing text requesting data entry is to use the format property.

    For text it would be

    @;"Enter Name"

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

Similar Threads

  1. Forms With names instead of ID
    By mikevdv in forum Forms
    Replies: 2
    Last Post: 01-31-2019, 06:17 PM
  2. Replies: 7
    Last Post: 03-21-2018, 04:58 AM
  3. Parameter Value for Deleted Field?
    By PATRICKPBME in forum Reports
    Replies: 2
    Last Post: 07-21-2017, 10:26 AM
  4. delete query produce #deleted in all deleted values
    By learning_graccess in forum Queries
    Replies: 2
    Last Post: 03-31-2012, 07:20 AM
  5. Replies: 4
    Last Post: 04-01-2009, 08:49 PM

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