Results 1 to 1 of 1
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Expression on Report #Name?

    I don't know why, I have asked about this before but to no resolve my code does not show correctly. It is a TextBox on the report.
    The code runs from a subform on a main form is the trick, I think. Main form is named CheckRegister and subform is named FReg
    StartDate and EndDate are 2 unbound fields on the subform. Syntax Error I suppose referring to the form.

    Code on the Report is Below:

    ="Check Reconciliation for
    the Time Period of " & [Forms]![FReg]![StartDate] & " thru " & [Forms]![FReg]![EndDate]

    Okay, I solved it and here is what worked.

    ="Check Reconciliation for
    the Time Period of " & [Forms]![CheckRegister]![Check Register].[Form]![StartDate] & " " & "thru" & " " & [Forms]![CheckRegister]![Check Register].[Form]![EndDate]
    Last edited by burrina; 01-06-2013 at 03:07 AM. Reason: Solved it,here is what worked.

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

Similar Threads

  1. Report Expression Building
    By KMac in forum Reports
    Replies: 7
    Last Post: 12-07-2012, 11:29 AM
  2. Replies: 2
    Last Post: 11-20-2012, 03:21 AM
  3. Report - Expression Builder
    By AndreasPanayiotou in forum Reports
    Replies: 3
    Last Post: 09-16-2012, 01:10 AM
  4. Replies: 5
    Last Post: 03-13-2012, 11:53 AM
  5. Calculated expression in report
    By Grizz2 in forum Reports
    Replies: 3
    Last Post: 12-20-2010, 08:50 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