Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-05-2017, 01:52 PM   #1
jackwail
Newly Registered User
 
Join Date: Dec 2017
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
jackwail is on a distinguished road
Missing fields

I have a database with 35 fields. The database has fields that have "disappeared". The information contained within the fields still shows up on the queries and in the reports I had previously established. But the field columns no longer show in the table. I need to make changes to the data in the fields but can not do so. When I switch from from datasheet view (where fields are missing) to the design view the fields still show as part of the table list.

Any help would be greatly appreciated.

Jack

jackwail is offline   Reply With Quote
Old 12-05-2017, 02:22 PM   #2
MarkK
Super Moderator
 
MarkK's Avatar
 
Join Date: Mar 2004
Location: Vancouver BC
Posts: 7,251
Thanks: 8
Thanked 1,181 Times in 1,124 Posts
MarkK is a glorious beacon of light MarkK is a glorious beacon of light MarkK is a glorious beacon of light MarkK is a glorious beacon of light MarkK is a glorious beacon of light MarkK is a glorious beacon of light
Almost certainly someone has simply dragged the column edge so the column has a zero width. To solve this, hover the mouse over the header row--where the column names are--and hover the mouse over the line between columns. Where there is a zero-width column the cursor will show a split vertical bar. Drag that bar to right to size the width of the hidden column.
Mark
__________________
formerly known as lagbolt | Windows 10 | Access 2010 | Visual Studio 2013 | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky
MarkK is offline   Reply With Quote
Old 12-05-2017, 02:26 PM   #3
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Posts: 399
Thanks: 6
Thanked 66 Times in 65 Posts
Mark_ is on a distinguished road
Re: Missing fields

To compliment Mark's response, also put your cursor on any field heading and RIGHT CLICK. Look for Unhide. Someone may have hidden fields.

Mark_ is offline   Reply With Quote
The Following User Says Thank You to Mark_ For This Useful Post:
jackwail (12-06-2017)
Old 12-06-2017, 11:03 AM   #4
jackwail
Newly Registered User
 
Join Date: Dec 2017
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
jackwail is on a distinguished road
Re: Missing fields

Thanks that worked
jackwail is offline   Reply With Quote
Old 12-06-2017, 11:13 AM   #5
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Posts: 399
Thanks: 6
Thanked 66 Times in 65 Posts
Mark_ is on a distinguished road
Re: Missing fields

Quote:
Originally Posted by jackwail View Post
Thanks that worked
Which piece of advice?
Mark_ is offline   Reply With Quote
Old 12-06-2017, 12:10 PM   #6
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 2,918
Thanks: 52
Thanked 686 Times in 634 Posts
ridders has a spectacular aura about ridders has a spectacular aura about
Re: Missing fields

Quote:
Originally Posted by Mark_ View Post
Which piece of advice?
He's hidden it. You'll need to unhide his answer!
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
, Tapatalk


If this answer has helped, please click the Thanks button and/or click the 'reputation' scales symbol on the left and leave a comment. Cheers!
ridders is offline   Reply With Quote
Old 12-06-2017, 12:53 PM   #7
jackwail
Newly Registered User
 
Join Date: Dec 2017
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
jackwail is on a distinguished road
Re: Missing fields

I just right clicked and unhide the three columns.


jackwail is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fields missing on Tab order form jovana Forms 7 04-09-2015 01:26 PM
Count how many fields are missing for each record ? Nyanko Queries 2 06-27-2013 06:46 AM
Missing Fields in Report MDavidCrompton Reports 5 03-28-2012 05:54 AM
Missing Fields TKnight Queries 3 07-21-2003 03:36 AM
Tab Order: My fields are missing Romulus Forms 2 02-27-2002 12:57 PM




All times are GMT -8. The time now is 11:04 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World