name string

[Dan @BCBS]

I don't get what I'm doing wrong.. The first code below works and displays a
message when no data is entered. The second code is where I'm attempting to
put the first and last name in a text box, but I get no data returned...

Works:
=IIf([PV_LASTNAME] Is Null And [PV_FIRSTNAME] Is Null,"Provider Not Entered")

Don't work:
=IIf([PV_LASTNAME] Is Null And [PV_FIRSTNAME] Is Null,"Provider Not
Entered",Trim(formatfield([PV_LASTNAME]) & ", " &
formatfield([PV_FIRSTNAME])))

 

[Ofer Cohen]

What is the formatfield function, is it a function you created?
If so, where did you create it?

It need to be either in a module or in the current form where the text box in.

 

[Dan @BCBS]

I have a very large public module which is a mess and I'd like to eliminate
it all together...

Can I merge the First Name and Last Name into this cell if a value was
entered.
I'm pretty sure I did this a long time ago using Trim but I cannot remember
exactally what I did..

What is the formatfield function, is it a function you created?
If so, where did you create it?

It need to be either in a module or in the current form where the text box in.

--
Good Luck
BS"D

I don't get what I'm doing wrong.. The first code below works and displays a
message when no data is entered. The second code is where I'm attempting to
put the first and last name in a text box, but I get no data returned...

Works:
=IIf([PV_LASTNAME] Is Null And [PV_FIRSTNAME] Is Null,"Provider Not Entered")

Don't work:
=IIf([PV_LASTNAME] Is Null And [PV_FIRSTNAME] Is Null,"Provider Not
Entered",Trim(formatfield([PV_LASTNAME]) & ", " &
formatfield([PV_FIRSTNAME])))

 

[Ofer Cohen]

Remove this function name, try

=IIf([PV_LASTNAME] Is Null And [PV_FIRSTNAME] Is Null,"Provider Not
Entered",[PV_LASTNAME] & (", " + [PV_FIRSTNAME]))


--
Good Luck
BS"D

I have a very large public module which is a mess and I'd like to eliminate
it all together...

Can I merge the First Name and Last Name into this cell if a value was
entered.
I'm pretty sure I did this a long time ago using Trim but I cannot remember
exactally what I did..

What is the formatfield function, is it a function you created?
If so, where did you create it?

It need to be either in a module or in the current form where the text box in.

--
Good Luck
BS"D

I don't get what I'm doing wrong.. The first code below works and displays a
message when no data is entered. The second code is where I'm attempting to
put the first and last name in a text box, but I get no data returned...

Works:
=IIf([PV_LASTNAME] Is Null And [PV_FIRSTNAME] Is Null,"Provider Not Entered")

Don't work:
=IIf([PV_LASTNAME] Is Null And [PV_FIRSTNAME] Is Null,"Provider Not
Entered",Trim(formatfield([PV_LASTNAME]) & ", " &
formatfield([PV_FIRSTNAME])))

 

[Dan @BCBS]

That did it, thanks