Functions in reports - howto refer to a field?

• • Reply

  13 years ago

  by joedbug

  Okon Joseph

  , Nigeria

  Joined 13 years ago

  Hi,

  I have an access 2002 report whose RecordSource property is a query, and which contains a textbox whose ControlSource property is a user-defined function like this; 

  =AccountHolder()

  How do I refer to fields in the query from within the AccountHolder() function? Eg.

  Private Function AccoutHolder() as String

        'Code here to return the Name field of the report's query.

  End Function

  I had expected to be able to use Me!Name like on a form, but it raises an error - "... can't find the field xyz"

  Thanks.

  Report abuse
• • Reply

  12 years ago

  by joe90

  J Alan

  , United Kingdom

  Joined 15 years ago

  Thats due to the fact that the field doesn't exist on the form.

  Drop the field on the  report, set its Visible property to "no" and you'll then be able to reference it in the code under the report.

  Joe 

  Report abuse
• • Reply

  12 years ago

  by joedbug

  Okon Joseph

  , Nigeria

  Joined 13 years ago

  Thanks Joe.

  I found another workaround which is to pass the field value to the function as a parameter eg.

  =AccountHolder([name])

  Thanks again.

  Report abuse
• • Reply

  12 years ago

  by joe90

  J Alan

  , United Kingdom

  Joined 15 years ago

  Yip.... that'll work too.

  Glad you got it sorted

  Joe
   

  Report abuse