grouplevel and val()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am setting my group levels with code in the Open Event of my report. My
Grouplevel(0) is a text field and I want to use the val() function when
sorting this field. I tried putting the val() around the Grouplevel code in
the Open Event and I also tried it in the sorting & grouping in the report:
=val(Grouplevel(0)). Is there a way to do this?

Thanks for your help.

Sarah
 
If I understand correctly, you should be able to use something like:

Me.GroupLevel(0).ControlSource = "=Val([Your Expression])"
 
Sarah said:
I am setting my group levels with code in the Open Event of my report. My
Grouplevel(0) is a text field and I want to use the val() function when
sorting this field. I tried putting the val() around the Grouplevel code in
the Open Event and I also tried it in the sorting & grouping in the report:
=val(Grouplevel(0)). Is there a way to do this?
Click to expand...


I think you want to set the group level's control source to
something like:

Me.GroupLevel(0).ControlSource = "=Val(thefield)"
 
Back
Top