mauddib6

Placed after the loop in the previous post, this will take out leading and trailing carriage returns. If [Left(field,1)=” ¶”] Set Field[“field”, “Right( field, Length(field)-1 )” End If If [Right(field,1)=” ¶”] Set Field[“field”, “Left(field, Position( field, "¶" ,1, PatternCount(field, "¶" ))-1)”] End If

I just have Pro and not Advanced, so I can't use the Custom function feature. I am still working on the leading and trailing carriage returns, but this eliminates all of the "middle" carriage returns. Loop If [“PatternCount(field, “¶¶”)>0 Set Field [“field”, “Replace(field, Position(FirstName, “¶¶”,1,1),2,” ¶”] End If Exit Loof If[“PatternCount(field, “¶¶”)=0”] End Loop

Thank you for the quick response. I tried what you said, but it only seems to partially work. It will find the double carriage return. But, it will not replace it with a single or for that matter any other number of carriage returns. It also won't find two carriage returns if it is at the end of the field (which is the most likely place a user will put it.)

I am trying to use the find/replace feature to eliminate user entry errors when they hit the "enter" button twice while typing in a list. I can't seem to find a way to make it find the carriage returns. - Would I have to do all of this in a calc field.

Thank you so much. I feel like one of those idiots to whom you say, "Why don't you just read the instructions." I was reading some books on FM for IWP, but did not even think about checking the FM documentation. Have a great day.

I have been using FM for 3 years, but have never had a need to publish on the web till now. Are there security risks in IWP for the computer since you are making an IP address available on the web. We are behind a pretty secure firewall, but did not want to make any compromises. Can people "sneak" into other databases such as a related one? Thanks for your help.

I had not thought of doing the parsing with a global. That sounds like a pretty easy thing to do, so I'll get to work on that. Thank you so much. I have been running it with the workaround for about a year and a half, but it takes a lot of extra steps whenever I want to do something new with the script.

I had not thought of doing the parsing with a global. That sounds like a pretty easy thing to do, so I'll get to work on that. Thank you so much. I have been running it with the workaround for about a year and a half, but it takes a lot of extra steps whenever I want to do something new with the script.

I had not thought of doing the parsing with a global. That sounds like a pretty easy thing to do, so I'll get to work on that. Thank you so much. I have been running it with the workaround for about a year and a half, but it takes a lot of extra steps whenever I want to do something new with the script.

Thanks. That clears up why it won't accept the data. I have been looking for other posts about doing data entry without using the mouse every time, but have not found anything. Do you know of any or an alternate way to accomplish this. I can use the work-around of creating a new record like I mentioned above, but it just does not seem efficient to just create and delete records willy nilly

Thanks. That clears up why it won't accept the data. I have been looking for other posts about doing data entry without using the mouse every time, but have not found anything. Do you know of any or an alternate way to accomplish this. I can use the work-around of creating a new record like I mentioned above, but it just does not seem efficient to just create and delete records willy nilly

Thanks. That clears up why it won't accept the data. I have been looking for other posts about doing data entry without using the mouse every time, but have not found anything. Do you know of any or an alternate way to accomplish this. I can use the work-around of creating a new record like I mentioned above, but it just does not seem efficient to just create and delete records willy nilly

I created a script that would allow the user to type a name and then hit enter to be able to enter another name. I am using a custom dialogue box with one input field for name. Button 1= OK Button 2=Finished Button 3=Quit. I run the dialogue inside a loop that has an (exit loop if status(currentmessagechoice=2)and creates a new record every time you click ok. It works great until reaching the last record. After clicking button 2 it exits the loop, but the data that was typed in the field input is not there for the last record. The only way I have found around this is to have it create a new record, click finished, then delete this record. Any suggestions or even a better way to do data entry for long lists without mouse clicks.

I created a script that would allow the user to type a name and then hit enter to be able to enter another name. I am using a custom dialogue box with one input field for name. Button 1= OK Button 2=Finished Button 3=Quit. I run the dialogue inside a loop that has an (exit loop if status(currentmessagechoice=2)and creates a new record every time you click ok. It works great until reaching the last record. After clicking button 2 it exits the loop, but the data that was typed in the field input is not there for the last record. The only way I have found around this is to have it create a new record, click finished, then delete this record. Any suggestions or even a better way to do data entry for long lists without mouse clicks.

I created a script that would allow the user to type a name and then hit enter to be able to enter another name. I am using a custom dialogue box with one input field for name. Button 1= OK Button 2=Finished Button 3=Quit. I run the dialogue inside a loop that has an (exit loop if status(currentmessagechoice=2)and creates a new record every time you click ok. It works great until reaching the last record. After clicking button 2 it exits the loop, but the data that was typed in the field input is not there for the last record. The only way I have found around this is to have it create a new record, click finished, then delete this record. Any suggestions or even a better way to do data entry for long lists without mouse clicks.