Link to home
Start Free TrialLog in
Avatar of Moonshadow
Moonshadow

asked on

Wrapping text within a Lotus Notes checkbox field?

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
Avatar of AndrewJayPollack
AndrewJayPollack

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).
Avatar of Moonshadow

ASKER

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.  ;-)
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
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?
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!
ASKER CERTIFIED SOLUTION
Avatar of AndrewJayPollack
AndrewJayPollack

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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