Solved

Datasheet view

Posted on 1998-12-24
7
300 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
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

821 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