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. 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.

Share This Page