• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

Access Report Problem

I have created a report in Access 2013.  On the detail I have a Text Box and a Command Button.  When the Command is clicked I want to perform an action based on the content of the Text Box.  How do I get the content of the Text Box???
0
Ray Turner
Asked:
Ray Turner
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You refer to a Textbox like this:

Me.NameOfYourTextbox

So if I wanted to popup a Msgbox:

Msgbox "Value is  " & Me.NameOfYourTextbox

However, on a Report, you will have multiple instances of the TExtbox, if you're referring to one in the Detail or Group sections of your report.
0
 
Ray TurnerSenior ConsultantAuthor Commented:
I'm referring to the one in the Detail Group.
0
 
Ray TurnerSenior ConsultantAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for rgturner's comment #a39942496

for the following reason:

Reference an item in the Group band the same way you reference an item in the Detail band.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Wasn't that basically what I told you - that you reference the two the same way?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now