Solved

Datasheet view

Posted on 1998-12-24
7
296 Views
Last Modified: 2012-06-21
I need my form to be a datasheet. But in this case the headings of columns are the field names, not the captions. But it does't suit me (the name like Person_ID is not good for the user). How can I change it?
0
Comment
Question by:Stern
  • 4
  • 2
7 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 50 total points
Comment Utility
You can't change it. You can create continuous form , that looks like datasheet form.
0
 

Expert Comment

by:bs316
Comment Utility
stern if you drag the field from the field list, you should see a ^label^ and ^textbox or combo^ box.
for example ^Person_ID^ change the text box to ^Person ID^ and you can see the difference
0
 

Expert Comment

by:bs316
Comment Utility
stern if you drag the field from the field list, you should see a ^label^ and ^textbox or combo^ box.
for example ^Person_ID^ change the text box to ^Person ID^ and you can see the difference
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 7

Expert Comment

by:spiridonov
Comment Utility
bs316, dragging fields from field list applies to Single form and contnuous form view only,not to datasheet view.
0
 

Expert Comment

by:bs316
Comment Utility
i don't know but if you try create a new form and drag a field down and change the text box then limit the view to datasheet only and you will see what i mean
0
 

Expert Comment

by:bs316
Comment Utility
sorry what i mean is the label not the text box
if you change the label you can change the display

0
 

Author Comment

by:Stern
Comment Utility
Ok, spiridonov, I also see no other possibility. Changing labels gives nothing. The points are in any case yours. Thanks.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now