Hidden Field in Datasheet view for a table
in [Tables]
|
From: Sam Berry on 15 Dec 2009 16:55 Hello All, when I go to Table Design, there is a column named Field 1 (it is text). When I switch to Datasheet View, it becomes hidden. Any ideas on how to solve the problem? Thanks in advance Sam Berry
From: Jeff Boyce on 15 Dec 2009 18:24 "Hidden" as in zero-width, or "hidden" as in "off-screen"? 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. "Sam Berry" <SamBerry(a)discussions.microsoft.com> wrote in message news:A36C3FB8-9677-4D07-A646-19F18CA78CEB(a)microsoft.com... > Hello All, > when I go to Table Design, there is a column named Field 1 (it is text). > When I switch to Datasheet View, it becomes hidden. > > Any ideas on how to solve the problem? > > Thanks in advance > Sam Berry
From: Sam Berry on 16 Dec 2009 10:58 Hidden as in "off screen" is the issue. I can see it in table design right underneath the PK, but when switching to Databasheet view, it is not visible Table Design View ID Field 1 Field 2 Datasheet view Id Field 2 "Jeff Boyce" wrote: > "Hidden" as in zero-width, or "hidden" as in "off-screen"? > > 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. > > "Sam Berry" <SamBerry(a)discussions.microsoft.com> wrote in message > news:A36C3FB8-9677-4D07-A646-19F18CA78CEB(a)microsoft.com... > > Hello All, > > when I go to Table Design, there is a column named Field 1 (it is text). > > When I switch to Datasheet View, it becomes hidden. > > > > Any ideas on how to solve the problem? > > > > Thanks in advance > > Sam Berry > > > . >
From: Jeff Boyce on 16 Dec 2009 11:41 Sam I was thinking more that "field99" would probably not show on-screen without scrolling. It sounds like that column is "hidden". Have you tried searching Access HELP concerning hiding and unhiding columns? 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. "Sam Berry" <SamBerry(a)discussions.microsoft.com> wrote in message news:006ECD33-4E2D-4961-B7EB-944E100CABE6(a)microsoft.com... > Hidden as in "off screen" is the issue. I can see it in table design > right > underneath the PK, but when switching to Databasheet view, it is not > visible > > Table Design View > ID > Field 1 > Field 2 > > Datasheet view > Id > Field 2 > > > > "Jeff Boyce" wrote: > >> "Hidden" as in zero-width, or "hidden" as in "off-screen"? >> >> 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. >> >> "Sam Berry" <SamBerry(a)discussions.microsoft.com> wrote in message >> news:A36C3FB8-9677-4D07-A646-19F18CA78CEB(a)microsoft.com... >> > Hello All, >> > when I go to Table Design, there is a column named Field 1 (it is >> > text). >> > When I switch to Datasheet View, it becomes hidden. >> > >> > Any ideas on how to solve the problem? >> > >> > Thanks in advance >> > Sam Berry >> >> >> . >>
From: Dale Fye on 16 Dec 2009 16:56
What data types are fields one and two (text, memo, number)? Is the form based off the table, or a query? If a Query, what sequence are the fields listed in? Seems to me that the width of field 2 could be pushing field1 off the visible area of the screen. Is there a horizontal scroll bar visible? ---- Dale "Sam Berry" wrote: > Hidden as in "off screen" is the issue. I can see it in table design right > underneath the PK, but when switching to Databasheet view, it is not visible > > Table Design View > ID > Field 1 > Field 2 > > Datasheet view > Id > Field 2 > > > > "Jeff Boyce" wrote: > > > "Hidden" as in zero-width, or "hidden" as in "off-screen"? > > > > 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. > > > > "Sam Berry" <SamBerry(a)discussions.microsoft.com> wrote in message > > news:A36C3FB8-9677-4D07-A646-19F18CA78CEB(a)microsoft.com... > > > Hello All, > > > when I go to Table Design, there is a column named Field 1 (it is text). > > > When I switch to Datasheet View, it becomes hidden. > > > > > > Any ideas on how to solve the problem? > > > > > > Thanks in advance > > > Sam Berry > > > > > > . > > |