Results 1 to 3 of 3
  1. #1
    Girraffa is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    32

    Unhappy Mismatched label-control associations in report despite multiple attempts to rectify


    Hello! I am having a bizarre issue with labels in a report. I have five time fields that are used in four calculated fields that give intervals between the times in minutes. I have added labels that say "minutes" after each calculated field to specify units. When I go to associate these labels with the appropriate calculated fields I open up the dialogue and pick the control. However Access highlights a different field that does not have that name. What the heck is happening here? Also the labels keep jumping around on the report when I close and re-open it. I've tried just closing and re-opening Access and it keeps happening. I am very curious if this is a weird quirk related to calculated fields or if there's something weird I am doing.
    the calculated fields are quite simple, all this code with different time inputs, this is in their control sources:
    =DateDiff("n",[txtTimeSternal],[txtTimeRecover])
    For example in the first picture I was trying to choose the control that is immediately to the left of the label, and when I choose the name of that control ("txtCalcDown") it highlights a different control that is named "txtTimeProcEnd" (see second photo for confirmation). When I scroll through the options it also highlights other controls with the wrong name. I can just leave them unassociated but I'm worried this is indicative of a larger problem so I figured I'd invoke the experts. Thank you for any help!
    Click image for larger version. 

Name:	Associate1.jpg 
Views:	16 
Size:	150.4 KB 
ID:	32255
    Click image for larger version. 

Name:	Associate2.JPG 
Views:	16 
Size:	120.1 KB 
ID:	32256

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Never encountered this. Shouldn't matter that the textboxes have expressions. Are you sure about the control names?

    Can't have more than one label associated with the same data control. Not really necessary for label to be associated unless you want to set textbox as not visible and have the label be not visible as well.

    Run Compact & Repair and if still have an issue, consider uploading db. Following instructions at bottom of my post.
    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
    Girraffa is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    32
    I have triple-checked the control names. I didn't know you could only associate one label with a control, maybe that is where the problem lies: I will leave them unassociated. Thank you for the help, sorry for the delay in response!

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

Similar Threads

  1. Replies: 3
    Last Post: 11-20-2015, 11:06 AM
  2. Comparison Query with mismatched columns
    By gaker10 in forum Queries
    Replies: 17
    Last Post: 10-27-2014, 11:42 AM
  3. Replies: 3
    Last Post: 07-21-2013, 08:05 AM
  4. Replies: 3
    Last Post: 09-12-2011, 12:53 AM
  5. Replies: 1
    Last Post: 04-29-2010, 05:15 PM

Tags for this Thread

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