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?