Inserting tabs (or only spaces) in Datasheet view

#1 (**permalink**) 19-Nov-2005, 22:00 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7749-inserting-tabs-only-spaces-datasheet-view.html
changes my spaces to an empty cell. How do I combat this? Also, how would I
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7749
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 (**permalink**) 19-Nov-2005, 22:00 PM

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...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7749

Regards

Jeff Boyce

"XjeaxaxX" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7749
> 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!
>

#3 (**permalink**) 19-Nov-2005, 22:00 PM

On Fri, 18 Nov 2005 15:37:02 -0800, "XjeaxaxX"
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7749
>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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7749
>
>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]