Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Since you are the fastest answering community around I throws this at you as it's urgent. [:)]
I have an application where we make data reduction when publishing on the server. Each reduced application then have one or several selections in 3 different fields available in a multi box. My problem is that I need to have a selection made on application load when there is only one value available in a field. White has to become green!
Any suggestions on this?
Hello,
It depends on which version of QV are you using, but in version 9 you can select "Actions" for a sheet (let's say some pre-programmed macros) that will do for you. Check sheet properties, go to Actions, On Activate, Action Type "Select", "Select in a field" and in the expression boxes enter the expressions for field and possible values that has to be selected.
Regards.
Hello,
It depends on which version of QV are you using, but in version 9 you can select "Actions" for a sheet (let's say some pre-programmed macros) that will do for you. Check sheet properties, go to Actions, On Activate, Action Type "Select", "Select in a field" and in the expression boxes enter the expressions for field and possible values that has to be selected.
Regards.
Thank you for your suggestion.
We use 8.5 and I solved it with a macro.
set FldComp = ActiveDocument.Fields("Company_Name").GetSelectedValues
set FldComp_p = ActiveDocument.Fields("Company_Name").GetPossibleValues
if FldComp.count = 0 and FldComp_p.count = 1 then
ActiveDocument.Fields("Company_Name").Select "*"
end if