Solved

Datasheet view

Posted on 1998-12-24
7
302 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 50 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 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