7 Replies Latest reply on Dec 8, 2009 8:07 AM by mrvodka

    selecting text  on a record

    fluffyone

      Title

      selecting text  on a record

      Post

      Hi group

       

      I have created a text box on a form, and I have got it to show the data from 6 fields in the current record showing and in this case it shows the contact name followed by the address details.

       

      What I would like to do when viewing the record is to select this group of data that is showing in the text box and copy and paste it into other applications. however although I have got the text box to display the right data I can't select the text to copy and paste it?

       

      is there a way around this?

       

      Regards

       

      Fluffy

        • 1. Re: selecting text  on a record
          mrvodka
             Do you have the field non-enterable? Why can you select the text?
          • 2. Re: selecting text  on a record
            fluffyone
              

            Hi Mr Vodka

             

            It is a text object on the form, as opposed to a field in the database. I can't see how I can make it enterable.

            in the text box I have:

            <<Customer _ company name>>

            <<ADDRESS1>>

            <<ADDRESS2>>

            <<ADDRESS3>>

            <<CITY>>

            <<COUNTY>>

            <<POSTAL CODE>>

             

            and this pulls in all the data from the different fields as a group of text, which works fine but I can't then select it to copy it, to then paste it into other applications on the computer.

             

            regards

             

            Fluffy

            • 3. Re: selecting text  on a record
              mrvodka
                

              Well these are merge fields so of course you cant copy them ( think of merge fields in word ). You can however, create a calc field that does essentially the same thing and then allow the users to copy that.

               

              Assuming that ADDRESS2 and ADDRESS3 are optional...

               

              Customer _ company name & ¶ &

              ADDRESS1 & ¶ &

              Case ( not IsEmpty ( ADDRESS2 ); ADDRESS2 & ¶ ) &

              Case ( not IsEmpty ( ADDRESS3 ); ADDRESS3 & ¶ ) &

              CITY & ¶ &

              COUNTY & ¶ &

              POSTAL CODE

              • 4. Re: selecting text  on a record
                fluffyone
                  

                Hi Mr Vodka

                 

                That worked thanks, although now I need to work out how to remove the blank lines when some of the optional fields are empty, I have done this before just need to try and remember.

                 

                 

                Regards

                 

                Fluffy

                • 5. Re: selecting text  on a record
                  mrvodka
                     The calc I posted should have worked for you. Are you sure that you have the exact syntax?
                  • 6. Re: selecting text  on a record
                    fluffyone
                      

                    Hi Mr Vodka

                     

                    Sorry, I had a play last night. It was working after all, I didn't look close enough. What was happening was there were other fields that were blank and when I saw gaps as I quickley wizzed through a few records I assumed this needed looking at. I have now changed the code a bit to include sliding on all lines

                     

                    how do I learn how to use this programing code? are there books available or on-line tutorials? what is a ¶ and how do I get it on a keyboard?

                     

                    Thanks for your help.

                     

                    regards

                     

                    Fluffy

                    • 7. Re: selecting text  on a record
                      mrvodka
                        

                      That is a pilcrow and it is used for a carriage return. You will see it under the operators section of the calc expression window.

                       

                      There are some books out there. I would recommend Geoff Coffey's book (The Missing Manual) as Geoff has a tendency to explain things simply. I recommend it for beginners.