Solved

Datasheet view

Posted on 1998-12-24
7
298 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Date/Time to SQL Datetime2(7) 9 25
Dynamically Reorder List Box 4 37
Display label on subreport when NO DATA on subreport 4 22
Access on Mouse move 5 31
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

776 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