grouplevel and val()

[Sarah]

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

 

[Duane Hookom]

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

Me.GroupLevel(0).ControlSource = "=Val([Your Expression])"

 

[Marshall Barton]

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?

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

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

 

[Sarah]

This did the trick.

Thanks,

Sarah