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

    johntincrow
    Expand Collapse
    Guest

    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
    Guest

    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
    http://www.datastrat.com
    http://www.mvps.org/access

    "johntincrow" <johntincrow@discussions.microsoft.com> wrote in message
    news:DB2CDFB5-2729-4869-AB14-41962DAF20E0@microsoft.com...
    >I want to be able to type in several rows of text in a single cell.
     

Share This Page