Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to Repeat Text in Multiple Record Fields?

Discussion in 'Information Technology' started by Larry Bohen, Jul 28, 2006.

  1. Larry Bohen

    Larry Bohen
    Expand Collapse
    Guest

    I want to repeat the same text in the same field in multiple Access 2003 SP2
    records.

    How do I do this?

    --
    Larry Bohen
    www.audiobooksonline.com
     
  2. Loading...


  3. Jeff C

    Jeff C
    Expand Collapse
    Guest

    You could try opening your table in design mode and then highlight the field
    you want the repeated text in. At the botton in the property box for the
    field there is a "Default Value" property. Put the text you want in there.
    --
    Jeff C
    Live Well .. Be Happy In All You Do


    "Larry Bohen" wrote:

    > I want to repeat the same text in the same field in multiple Access 2003 SP2
    > records.
    >
    > How do I do this?
    >
    > --
    > Larry Bohen
    > www.audiobooksonline.com
    >
    >
    >
     
  4. Larry Bohen

    Larry Bohen
    Expand Collapse
    Guest

    In that I want to insert text in muliple record fields for a subset of a
    11,100 record database, I can't use such a global method unless I am
    misunderstanding your idea.

    Thanks anyway.

    --
    Larry Bohen
    www.audiobooksonline.com
    "Jeff C" <JeffC@discussions.microsoft.com> wrote in message
    news:B0A5AEA7-6F50-44ED-B7E5-D258C54E2D41@microsoft.com...
    > You could try opening your table in design mode and then highlight the
    > field
    > you want the repeated text in. At the botton in the property box for the
    > field there is a "Default Value" property. Put the text you want in
    > there.
    > --
    > Jeff C
    > Live Well .. Be Happy In All You Do
    >
    >
    > "Larry Bohen" wrote:
    >
    >> I want to repeat the same text in the same field in multiple Access 2003
    >> SP2
    >> records.
    >>
    >> How do I do this?
    >>
    >> --
    >> Larry Bohen
    >> www.audiobooksonline.com
    >>
    >>
    >>
     
  5. Jeff C

    Jeff C
    Expand Collapse
    Guest

    Then build a query that returns the subset of records that you want, turn it
    into an update query entering the text you want in the field you want
    --
    Jeff C
    Live Well .. Be Happy In All You Do


    "Larry Bohen" wrote:

    > In that I want to insert text in muliple record fields for a subset of a
    > 11,100 record database, I can't use such a global method unless I am
    > misunderstanding your idea.
    >
    > Thanks anyway.
    >
    > --
    > Larry Bohen
    > www.audiobooksonline.com
    > "Jeff C" <JeffC@discussions.microsoft.com> wrote in message
    > news:B0A5AEA7-6F50-44ED-B7E5-D258C54E2D41@microsoft.com...
    > > You could try opening your table in design mode and then highlight the
    > > field
    > > you want the repeated text in. At the botton in the property box for the
    > > field there is a "Default Value" property. Put the text you want in
    > > there.
    > > --
    > > Jeff C
    > > Live Well .. Be Happy In All You Do
    > >
    > >
    > > "Larry Bohen" wrote:
    > >
    > >> I want to repeat the same text in the same field in multiple Access 2003
    > >> SP2
    > >> records.
    > >>
    > >> How do I do this?
    > >>
    > >> --
    > >> Larry Bohen
    > >> www.audiobooksonline.com
    > >>
    > >>
    > >>

    >
    >
    >
     

Share This Page