J
JimP
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.
http://s28.quicksharing.com/v/5304419/controlsource.jpg.html
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.
http://s28.quicksharing.com/v/8892670/TableFormView.jpg.html
FWIW, the two fields in the table do not have identical formatting in
Access -- the formatting is the way Access interpreted it upon
import.
http://s28.quicksharing.com/v/4717182/Design_View_Figure_Identifier_Field.jpg.html
http://s28.quicksharing.com/v/4842418/DesignView_Figure_Identifier_Description.jpg.html
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?
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.
http://s28.quicksharing.com/v/5304419/controlsource.jpg.html
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.
http://s28.quicksharing.com/v/8892670/TableFormView.jpg.html
FWIW, the two fields in the table do not have identical formatting in
Access -- the formatting is the way Access interpreted it upon
import.
http://s28.quicksharing.com/v/4717182/Design_View_Figure_Identifier_Field.jpg.html
http://s28.quicksharing.com/v/4842418/DesignView_Figure_Identifier_Description.jpg.html
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?