Default Value of field on form?

[d9pierce1]

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....

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

[xps35]

I looks like you want to add a label to the value of a field. That is no good idea. Use labels as labels and keep field values "clean".

If you still want to do this, I think you have to create an update query to adjust existing (not null) values. For new records set the default value property of the table field to "D.B.A.:".

[d9pierce1]

Its not a label, there are two txt boxes, one TxtDBA and one DBA... I want to take the value of DBA and put that value in
TxtDBA. and if nothing in DBA then TXTDBA would be blank
Thanks

[Bob Fitz]

I don't understand the requirement. Both textboxes are using the same Control Source (DBA) so if you change the value in either, the other will change as well.

[d9pierce1]

I got it fixed, I put the following in the query and it works as expected.
Thanks everyone

DBAName: IIf(IsNull([DBA]),"","DBA: " & [DBA])

[d9pierce1]

Hi Bob,
Hope you are well!
I was using this as my population for the address so when a company is DBA, then it will state that in my Address Box as a DBA: Some Company
Its all good! just needed to put it in a query rather then a default.
Thanks
Dave