Wrapping text within a Lotus Notes checkbox field?

Moonshadow
Moonshadow used Ask the Experts™
on
I'm sure this has been asked before, but I can't find anything useful on it...

I'm reading text from a field (via @DBColumn) and using that text to populate the available choices of a checkbox field.  So far, so good.

The problem occurs when I have a REALLY long string of text to put in as a choice (read: around 40-50 chars).  Even though I have the checkbox in a table with hard-coded margins, the checkbox does NOT wrap the text and pushes the right margin of the table off the screen.  Obviously, this isn't good.

Does anyone know:
a) a way to make the text wrap?
b) an alternate way for me to allow for a variable # of choices in a checkbox or similar construct?

Any help is, of course, highly valued.

Dave
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
well, you could make the text wrap but inserting an "@Newline" into the middle of the text (I think, I have not tried this in a radio button or checkbox).

Author

Commented:
A valiant attempt, but the checkbox ignores everything after the end of the first string.

I put the following code in the "formula for choices" area:

"blahblahblah" + @NewLine + "YaddaYaddaYadda"

When you bring the doc up, you'll see "blahblahblah" and that's it.

Good idea, but no dice.  I've also tried the same concept using @Char(10) and @Char(13) with failed results as well.

Dave
DAMN.  Curses, foiled again.   Have you tried changing the style of the box?   Perhaps using a layout region on your form instead of the free-flowing rich text?  

Sorry I don't have the ability to easily try this before suggesting it --I'm sitting in a hotel lobby at the Intercontental in Miami waiting to deliver a session right now.  ;-)
OWASP: Forgery and Phishing

Learn the techniques to avoid forgery and phishing attacks and the types of attacks an application or network may face.

Author

Commented:
Yet another interesting (I won't say good...I HATE layout regions) suggestion that Notes thwarts.  The checkbox actually appears to disregard the region entirely...both left-right as well as top-bottom!  :)

I'm thinkin' this isn't going to happen in R5.

Anyone know if R6 supports this kind of functionality?

Dave

Author

Commented:
Oh, and I've checked every freakin' option in the field/table/text parameters and nuttin' seems to help.

<sigh>

Dave
Are you the person who used to be a moderator here at EE ?
sorry moon, I'm stumped.

Could you make a blank checkbox with no text value, a | (pipe symbol) for the value you want stored, and then put a text next to the check of your own?

Author

Commented:
heh...funny you should mention that.  That's exactly how we're doing it right now.  It's also hard-coded that way.

The idea here was to make the contents of the checkbox variable, so that we in development wouldn't have to be involved every time they wanted to change the contents.

Doing it the way you suggest would require a hard-coded checkbox field for each question.  Since I don't know how many questions they'll have...  You get the idea.  :)

I hate to keep shooting down ideas, but I'm afraid there may not be an R5 way to do it.

<sigh>

Thanks for the help though.  If I don't get anything else useful, I'll give you the points just for the effort.  :)

Dave

P.S.  Arun...you could make a suggestion or two if you like.  :)  You know I respect your ideas!

   I did a screen shot and a demo database of my idea for you before reading your last update, but I think its still very relevant.   Why can't the text be a lookup field?  The text in the second column of my example.

I made sure the exmple is in r5 format for you.  check here.

http://www.thenorth.com/northern.nsf/html/bigboxes
oh, and creative use of hide when -- set a field on the form near the top with the TOTAL NUMBER OF ELEMENTS from a db lookup, then each field uses element number x to display, and hide when if the row number is higher than the total elements.  It all works.  ;-)  If you do the lookups in the query open, you don't even need to do a form refresh.

Author

Commented:
Yeah, I was thinking of putting together a "profile" document with about 20 options per "Section", with an index field of how many were actually used.  The user would then fill in as many as she needed, the index would auto-calculate the # of items.  A second form would only show the options defined.

This is a good solution, though again, I'd prefer to NOT hard-code anything (the 20 options).  Then again, beggars can't be choosers, so this may be my only option.  :)

Thanks for your insights!  I'll be sure to post something should I find a better answer.

Dave

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial