Assigning a value to a field in a report

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I want to assign a value to a field in a reoprt id a certain condition is
met.

Within my report's VBA module, I add the following lines:

If d Then
sFilter = "[ResearchID]=" & Forms!F_Research!txtResearchID

Me!txtNoteLong.Value = ""
Else

Me reprsents the report and txtNoteLong is a textbox on the report that I
want to assign a value to.

But using this code I get an error that says I "cannot assign a value to
this object" and "#Name?" displays on the report.

I do not understand. How can I assign a value to a field control on a
report?
 
Is txtNoteLong bound to a field or expression? I believe you can only use
code like this on unbound controls.
 
Hi Dave,

I wanted to post a quick note regarding the information MVP Duane Hookom
had sent to you to see whether you would like additional assistance or
information regarding this particular issue. We appreciate your patience
and look forward to hearing from you!

Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to assign value to controls on a Report 1
Assigning Values to a Control Box 2
assign record source 5
Reports and Date Increments 2
Access count a field in access report 2
Assigning Calculated value to main report from subreport 1
Sorting text field value in a report 4
averaging a field value if field value is greater then 0 access report 4

Back
Top