Thread: Differences? (Access '97)
2002-10-15, 12:07 #1
- Join Date
- Sep 2002
- Thanked 0 Times in 0 Posts
Differences? (Access '97)
What is the difference between a table's datasheet view and a form's datasheet view ? I thought I had all my data showing in my table, but it was my form's datasheet view I was looking at. My form's datasheet view shows the entire data, but not in the table's datasheet view. How can I get both to display the same data? Some of the fields are actually other fields in some mathematical form - these are the ones not showing in the table's datasheet view. Thanks in advance.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2002-10-15, 14:05 #2
- Join Date
- Mar 2002
- Thanked 15 Times in 15 Posts
Re: Differences? (Access '97)
In the design view of a form, you can create text boxes that are not bound to a field, but have an expression (formula) as control source. These text boxes will show up as extra columns in datasheet view.
Another difference is that you can have code behind a form, not behind a table.
Note: I don't like forms in datasheet view; users have too many opportunities to mess with column widths, hiding columns etc. If I want to display several records at a time, I use a continuous form.