Tommy, Anne, The extra CR on the end of the field value is part of the Windows clipboard copy-and-paste function.
If you train your users to carefully highlight just the actual value/text before copying they'll do just fine, but of course this is a very common error and we have to program around it. You can add an active link that fires on lose-focus, row change,etc, and will remove the CR ( or maybe it's CR/NL ) with REPLACE(), or you can do the same thing with a filter on the underlying form. LTRIM(RTRIM(FieldName)) may be helpful too. Doug -- Doug Blair +1 224-558-5462 Sent from my iPad2 Auto-corrected typos, misspellings and non-sequiturs are gratefully attributed to Steve Jobs :-) On Dec 21, 2011, at 10:47 AM, Tommy Morris <[email protected]> wrote: > ** > That also happens on the Remedy Login Field on CTM:People in the User Tool. > The “Row” property is just the number of Rows Displayed. > > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Ramey, Anne > Sent: Wednesday, December 21, 2011 10:33 AM > To: [email protected] > Subject: 2+rows in 1 row field > > ** > I have an issue where users are able to have more than one row in a one row > field, like incident number, in the mid-tier. I can make this happen myself. > If I copy and paste a cell from excel (not the contents, but the whole cell) > into the incident number field, it pastes in the incident number and an > end-of-line so you can’t see that you’ve actually put the incident number in > there (unless you move up a line with your cursor). That is just one > example, but it is one of the easiest to reproduce. Is there any way to > prevent this? I’ve had some people report accidentally putting an > end-of-line/soft-return in a field and then getting “stuck” in it and not > being able to get out of the field, which is why I ask. They haven’t yet > been able to tell me how they are doing that, but I am hoping there may be > some way to prevent it. > > I’m using ITSM 7.6.0 patch 1, ARS 7.5 and have tried this in Mid-tier 7.6 p4 > and 7.5 p7. It seems to happen in any browser. > > Thanks, > > Anne Ramey > > *********************************** > E-mail correspondence to and from this address may be subject to the North > Carolina Public Records Law and may be disclosed to third parties only by an > authorized State Official. > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
