Prev: need good database structure for tracking counter state
Next: Multiple subtables
From: Kory Urban on 4 May 2010 10:40
Hello Everyone,
I know I have seen this problem before and that I have corrected it
in
the past, but for some reason I can't figure it out this time or find
something similar online. The problem is simply, when I view a
certain
table one of its columns is completely filled in with "##########".
The data is still there because when I click on it the data appears,
and the data is visible in a justified form. It can't stay like this
but I can't figure how I did it in the first place or how to change
it
back. Any help would be greatly appreciated.

Thank You
From: Jeff Boyce on 4 May 2010 11:03
Kory

Like Excel, if you data stored exceeds the width of the column it's
displayed in, you get "###..."

Make the column wider.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Kory Urban" <badongguy(a)gmail.com> wrote in message
news:e41b53e5-2ea2-4b24-9040-7f7cf7164680(a)q32g2000yqb.googlegroups.com...
> Hello Everyone,
> I know I have seen this problem before and that I have corrected it
> in
> the past, but for some reason I can't figure it out this time or find
> something similar online. The problem is simply, when I view a
> certain
> table one of its columns is completely filled in with "##########".
> The data is still there because when I click on it the data appears,
> and the data is visible in a justified form. It can't stay like this
> but I can't figure how I did it in the first place or how to change
> it
> back. Any help would be greatly appreciated.
>
> Thank You


From: BruceM via AccessMonster.com on 4 May 2010 11:15
This is happening in Access? In Excel I would suggest you make the column
wider, but I have not seen this behavior that I can recall (in Access 2003,
anyhow).

Kory Urban wrote:
>Hello Everyone,
>I know I have seen this problem before and that I have corrected it
>in
>the past, but for some reason I can't figure it out this time or find
>something similar online. The problem is simply, when I view a
>certain
>table one of its columns is completely filled in with "##########".
>The data is still there because when I click on it the data appears,
>and the data is visible in a justified form. It can't stay like this
>but I can't figure how I did it in the first place or how to change
>it
>back. Any help would be greatly appreciated.
>
>Thank You

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201005/1

 | 
Pages: 1
Prev: need good database structure for tracking counter state
Next: Multiple subtables