blackcat Posted May 15, 2002 Share Posted May 15, 2002 Ok guys I'm having a brain freeze, I have a field that consists of 12 check box options. A user can select any number of these. I want to display all the selected options in another calculation text field that will display only the items selected in the check box field. Items to be seperated by a "," Ideas please Steve Quote Link to comment Share on other sites More sharing options...
andygaunt Posted May 15, 2002 Share Posted May 15, 2002 Hi Steve, How about in your calculation field you have Substitute( checkbox; "¶"; ",") make sure it is unstored. HTH Quote Link to comment Share on other sites More sharing options...
dj Posted May 15, 2002 Share Posted May 15, 2002 Originally posted by blackcat:[qb]Ok guys I'm having a brain freeze, I have a field that consists of 12 check box options. A user can select any number of these. I want to display all the selected options in another calculation text field that will display only the items selected in the check box field. Items to be seperated by a "," Ideas please Steve[/qb] Since the rapresentation of selected checkBoxField's options is carriage return separated list of items, thanSubstitute (checkBoxField, "¶", ", ") should work fine Dj Quote Link to comment Share on other sites More sharing options...
andygaunt Posted May 15, 2002 Share Posted May 15, 2002 DJ, great minds (that are currently unfrozen!) Quote Link to comment Share on other sites More sharing options...
blackcat Posted May 15, 2002 Author Share Posted May 15, 2002 Cheers Guys I knew that!! honest! its been a busy day. Steve Quote Link to comment Share on other sites More sharing options...
dj Posted May 15, 2002 Share Posted May 15, 2002 I wrote few letters more than you so you beat me Dj Quote Link to comment Share on other sites More sharing options...
blackcat Posted May 15, 2002 Author Share Posted May 15, 2002 Just to even the score a little I have to nominate DJ as the winner on this one as ANDY's version included ";" rather than "," for the seperators. Sorry andy! Steve Quote Link to comment Share on other sites More sharing options...
andygaunt Posted May 15, 2002 Share Posted May 15, 2002 Steve, depends what os system formats you are using. UK Mac is ; , is for US formats So, how can you hold that against me. OK, from now on I will use , as my seperator. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.