Expert advise is sort ,
I am using the listcount to obtain the number of rows in a combo box .The text box calculated control I am currently using gives the correct count, unless the number of rows is zero , in that case the output is -1 ,which is the same result as when I do not use minus columnheads .
Any pointers would be appreciated
Regards Ypma
I am using the listcount to obtain the number of rows in a combo box .The text box calculated control I am currently using gives the correct count, unless the number of rows is zero , in that case the output is -1 ,which is the same result as when I do not use minus columnheads .
Code:
=[Combo841].[ListCount]-Abs([Combo841].[ColumnHeads])
Any pointers would be appreciated
Regards Ypma