Recent content by adamsro

OnFormat event works as expected thanks again to everyone for your help

I do not see the onFormat event anywhere

using a macro

If WorkGroup = "control" Then controlpm.Visible = True End If

Hello, I have a report that is emailed out. For the report itself i have a onload event which will display information depending on the workgroup the report is for. This works fine when viewing the report but when i send the email it does not assuming it's because the onload event is not...

it all works now thanks so much for your help

oh my it was a spelling error #$#!@

yes query shows all numerical values in the days remaining field

when i look at the report the days remaining are right aligned I think that is what you are asking. So yes, it is numerical value as it matches all the other numerical fields are right aligned text fields in the report are left aligned

when i go to pick a control source in the report it is left aligned as well

The record source is a querie that has two tables one that holds the days remaining data type just shows as calculated. on the report property sheet is shows the days remaining as format general number. Sorry not really sure if im looking at the right place you are speaking about but from...

the calculated days remaining is from a SharePoint list. when i run the command without the sort i pull 4 items. all with the days remaining fields populated

made the changes plog suggessted still doesnt sort, i get a pop up window asking for days remaining value

days remaining is a calculated field based on 2 dates

Hello, I have a report i call to open but i would like to to only show items that are <= a numerical value that is entered before the form loads. Im trying to sort the days remaining field on the report by the value of the dtotext field. Ive tried various things, but nothing seems to work I...