Welcome to SPN

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

Sign Up Now!

How Do I Wordwrap In Cells In Access?

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

  1. johntincrow

    Expand Collapse

    I want to be able to type in several rows of text in a single cell.
  2. Loading...

  3. OP
    Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse

    There are no "cells" in Access. That is a spreadsheet concept. Access is a
    database that has columns (fields) and rows (records). You should never work
    directly in the tables, although you can work in datasheet view in a form. A
    data in a field in a form is represented usually with a control, which can
    be a textbox, combobox, etc.

    Now to more directly answer your question. A textbox can display multiple
    rows of data (1 record). You can turn on text wrapping by adding a vertical
    scrollbar from the property sheet, or you can use the shift + enter or ctrl
    + enter key combinations or VBA code to add a carriage return to the data.
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads

    "johntincrow" <johntincrow@discussions.microsoft.com> wrote in message
    >I want to be able to type in several rows of text in a single cell.
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page