This is just to simple, but I'm braindead today.
I have a form based on a table. The table has 3 fields: FirstName, LastName & FullName.
When I enter the FirstName and LastName, I want to populate the FullName field in the table.
Thanks,
jr
This is just to simple, but I'm braindead today.
I have a form based on a table. The table has 3 fields: FirstName, LastName & FullName.
When I enter the FirstName and LastName, I want to populate the FullName field in the table.
Thanks,
jr
Why do you even have a FullName field. You can *always* create it in a query.
As RuralGuy stated, Not a good idea most of the time.
The above can be used when needed on a form or report.
however, as per your request,
[FirstName] & " " & [LastName] as a calculated field.
Dale
Understood. This is a special situation.
I should have mentioned in the original post that this is Access 2007, which I don't think has the Calculated Field option in the table.
Any way around that?
None that I can think of.
Can you use a query?
Dale
You could certainly use an UPDATE query to fill the FullName field if need be.
Why can't you use a query? What makes it a special case? Most procedures cannot tell the difference between a table and a query.
We're not trying to be obstinate, just understand this special condition.
This is not my db. Just need to make a small change for a friend. There are other forms, reports and queries already built, and I was trying to avoid having to modify all of them. Guess I'll need to go through them all.
Thanks for your help.
jr
The FullName field has *always* been in this table?
Yes. The operator enters it separately from the FirstName and LastName. This was my friends first shot at using Access.
You don't use a Form? Just open the table for edit?
Gotcha.
Make a FullName field in a select query and use that query for the form rather than the table.
Dale
Thanks for your help. Muchly appreciated
Is this thread ready to use the Thread Tools at the top of the thread and mark as Solved?