?
Solved

Datasheet view

Posted on 1998-12-24
7
Medium Priority
?
303 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 7

Accepted Solution

by:
spiridonov earned 150 total points
ID: 1972040
You can't change it. You can create continuous form , that looks like datasheet form.
0
 

Expert Comment

by:bs316
ID: 1972041
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
ID: 1972042
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 7

Expert Comment

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

Expert Comment

by:bs316
ID: 1972044
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
ID: 1972045
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
ID: 1972046
Ok, spiridonov, I also see no other possibility. Changing labels gives nothing. The points are in any case yours. Thanks.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Suggested Courses

764 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