Test Business.zipHI all,
I have a txt box on a subform called DBA,
Form is frmBusiness
SubForm is sfrmBusiness
Source Object is sfrmEntity
I am trying to set the default value of this textbox TxtDBA to, if null then nothing, if not null, then what ever is in the textbox DBA formatted to D.B.A.: Whatever is in txtbox DBA
I have tried the following to no avail....
Code:
Iff IsNull([DBA])," ", D.B.A. & [DBA]
Iff IsNull([DBA])," ", "D.B.A." & [DBA]
IIf(IsNull([Forms]![sfrmEntity]![DBA])," "," DBA:" & ([Forms]![sfrmEntity]![DBA])
IIf(IsNull([Forms]![sfrmBusiness]![DBA])," "," DBA:" & ([Forms]![sfrmBusiness]![DBA]))
IIf(IsNull([Forms]![frmBusiness]![Form]![sfrmBusiness].[DBA])," "," DBA:" & ([Forms]![frmBusiness]![Form]![sfrmBusiness].[DBA]))
Any ideas?
I could maybe put something in the Qry also? Not real sure on that
Thanks
Dave