On May 30, 1:40 pm, Jerry Whittle
> The formatting, especially with the two different fields, will not allow you
> to add data into the table from that text box. You could display it that way;
> however, you need to enter data in both the data for the Figure Identifier
> and Description fields seperately.
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> "JimP" wrote:
> > I think I'm closer. I confess to being a newbie when it comes to
> > using
> > functions in Access, but I finally got my form to look as desired by
> > putting the following in my
> > Control Source for the field: =Format([Figure Identifier],"0000000" &
> > [Description] & ".eps"). So far, so good.
> > The table tied to the form was imported in Access from Excel, and the
> > form was then built on the table. Within the table, however, this
> > field is not populating when adding new records. Only the initial
> > row,
> > which was populated at the time of the import, still shows visible
> > data.
> > FWIW, the two fields in the table do not have identical formatting in
> > Access -- the formatting is the way Access interpreted it upon
> > import.
> > I would like the Figure Identifier Description field to populate in
> > the table, too, though this is perhaps not absolutely essential. What
> > is your advice for next steps?- Hide quoted text -
> - Show quoted text -
Thanks for this, Jerry. I appeciate the advice.