Full Name from FirstName LastName

[jhrBanker]

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

[RuralGuy]

Why do you even have a FullName field. You can *always* create it in a query.

[rzw0wr]

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

[jhrBanker]

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?

[rzw0wr]

None that I can think of.

Can you use a query?

Dale

[RuralGuy]

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?

You could certainly use an UPDATE query to fill the FullName field if need be.

[RuralGuy]

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.

[RuralGuy]

We're not trying to be obstinate, just understand this special condition.

[jhrBanker]

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

[RuralGuy]

The FullName field has *always* been in this table?

[jhrBanker]

Yes. The operator enters it separately from the FirstName and LastName. This was my friends first shot at using Access.

[RuralGuy]

You don't use a Form? Just open the table for edit?

[rzw0wr]

Gotcha.
Make a FullName field in a select query and use that query for the form rather than the table.

Dale

[jhrBanker]

Thanks for your help. Muchly appreciated

[RuralGuy]

Is this thread ready to use the Thread Tools at the top of the thread and mark as Solved?