1 Reply Latest reply on Jul 17, 2012 4:58 PM by philmodjunk

    Inserting large amount of text in to check box or drop down menu.

    danton31

      Title

      Inserting large amount of text in to check box or drop down menu.

      Post

      Hi, I am new to this database programming stuff and I apologize if this is a simple fix.

      I have done a lot of searching for this issue, but have not see any answers.

      My question is in two parts, I have the following text that I want to have in a dropdown menu or checkbox menu. When I insert the text in to the manage value list (text box) each line is separate. But I want to be able to choose the whole clause as one. 

      ABC Vol 1 Signs on doors

      (a)  A sign, to alert persons that the operation of certain doors must not be impaired must be installed where it can readily be seen on, or adjacent to, a –

      (i)

      (B) required  doors,

      On the side of the door that faces a person seeking egress and, if the door is fitted with a device for holding it in the open position, on either the wall adjacent to the doorway or both sides of the door

      (b)  A sign referred to in (a) must be in capital letters not less than 20mm high in a color contrasting with the background and state - 

       

      The second issue is that when i insert the above text to the field I can only see part of the text (it is cut off on the right side).

      I have completed a database and it is ready to be used, but the above issue is really bugging me, as it looks bad and people cannot see what they are choosing.

      Can any one help me please?

        • 1. Re: Inserting large amount of text in to check box or drop down menu.
          philmodjunk

          I suggest that you not set up your value list this way. Set up a table of records where a text field in each record stores one such block of text. Use a second field to provide a name or summary description of the text.

          Set up your value your value list to be a value list of the Name fields instead of the text.

          Use the selection of a value in this value list to link your record to one of the records in this table and then you can either display the text or copy it into a matching field.

          See this link for a description of these two options: Auto Fill