Welcome to SPN

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

Sign Up Now!

Inserting tabs (or only spaces) in Datasheet view

Discussion in 'Information Technology' started by XjeaxaxX, Nov 19, 2005.

  1. XjeaxaxX

    XjeaxaxX
    Expand Collapse
    Guest

    I'm entering data in my table via datasheet view. In some text fields, I
    want (for instance) three or four spaces, nothing else. Spaces are important
    to me. However, as soon as I hit enter or tab or an arrow key, Access
    changes my spaces to an empty cell. How do I combat this? Also, how would I
    enter a tab?

    I know ctrl+enter puts a carriage return in a text field, but ctrl (or
    shift) + tab (or space) do not do the trick for me.

    Thanks for any help!
     
  2. Loading...

    Similar Threads Forum Date
    India Woman stabs husband 35 times with ice-poker, arrested Breaking News Dec 5, 2011
    Opinion Punjab Police ‘Keeping Tabs’ on Gov't Rivals Punjab, Punjabi, Punjabiyat Aug 30, 2011
    Sikh News Priest kills wife, stabs himself (Outlook India) Breaking News May 9, 2008
    Sikh News Sikh woman stabs lover's wife to death (The Times of India) Breaking News Nov 14, 2007
    Did Guru Nanak really have the need to read the veds and ketabs Sikh Sikhi Sikhism Nov 30, 2004

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    If my form shows you a control that seems to have nothing in it, does it
    have spaces or a zero-length string, or does it have nothing (Null) for a
    value?

    You've decided that you need spaces for some purpose (undisclosed), but how
    are your users to make sense of what you would have Access store?

    If you describe a bit more about why you feel you need spaces, the 'group
    readers may be able to offer an alternative approach...

    Regards

    Jeff Boyce
    <Office/Access MVP>

    "XjeaxaxX" <XjeaxaxX@discussions.microsoft.com> wrote in message
    news:C7217A81-D873-48D6-AB21-C5BABF504A97@microsoft.com...
    > I'm entering data in my table via datasheet view. In some text fields, I
    > want (for instance) three or four spaces, nothing else. Spaces are
    > important
    > to me. However, as soon as I hit enter or tab or an arrow key, Access
    > changes my spaces to an empty cell. How do I combat this? Also, how
    > would I
    > enter a tab?
    >
    > I know ctrl+enter puts a carriage return in a text field, but ctrl (or
    > shift) + tab (or space) do not do the trick for me.
    >
    > Thanks for any help!
    >
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 18 Nov 2005 15:37:02 -0800, "XjeaxaxX"
    <XjeaxaxX@discussions.microsoft.com> wrote:

    >I'm entering data in my table via datasheet view. In some text fields, I
    >want (for instance) three or four spaces, nothing else. Spaces are important
    >to me. However, as soon as I hit enter or tab or an arrow key, Access
    >changes my spaces to an empty cell. How do I combat this? Also, how would I
    >enter a tab?
    >
    >I know ctrl+enter puts a carriage return in a text field, but ctrl (or
    >shift) + tab (or space) do not do the trick for me.
    >
    >Thanks for any help!


    Access trims trailing blanks from all text fields, and if this leaves
    nothing, it stores either a NULL or a zero-length string (depending on
    the properties of the field).

    As Jeff asks... What is the difference between the values

    and

    for the user?


    John W. Vinson[MVP]
     

Share This Page