Thanks, John. It worked as described. Ray.
--- In ms_access@yahoogroups.com, "John Viescas" <[EMAIL PROTECTED]> wrote: > Ray- > > When you design a form to be displayed in Datasheet view, the column > captions come from any attached label control, not the Caption defined for > the field in the table. Look at your form in Design view. If you have text > boxes with unattached labels, you must add labels with captions. You can > either delete and redefine the controls or add a label control, cut it to > the clipboard, select the text box control, and paste the label back to > associate it. Set the Caption of the label to what you want to see in > Datasheet view. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > > From: ms_access@yahoogroups.com > > [mailto:[EMAIL PROTECTED] On Behalf Of Ray Todd, Jr. > > Sent: Tuesday, May 10, 2005 1:15 PM > > To: ms_access@yahoogroups.com > > Subject: [ms_access] Forms (Subform) & Labels > > > > > > I have created two tables. Based upon these two tables, I created a > > Form which includes a subform. The problem that I am having and don't > > understand is when I open the Form (and hence the subform), the column > > labels for the subform (being viewed as datasheet) is using the field > > name, i.e., FirstName. I do have the caption as "First Name" in the > > captions in the table containing the First Name data. > > > > What am I missing, it was my understanding that by including a caption > > name, in the table any forms created using that table, the caption > > would be used for the column name instead of the field name. > > > > Any ideas would be helpful.. > > > > Thanks, > > > > Ray. > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
