Fomatting

E

Emma

I have the following in a text box, it works ok but when a LoanId number is
already in the database or imported in this doesn't do anything instead it
just shows the LoanId. Is there anyway to have it always show up? I was
thinking of before update?

=Format([DateofLoanAgreementSigned],"""HELP- ""yyyy""- 0""") & [LoanId]

THanks Emma
 
J

John W. Vinson

I have the following in a text box, it works ok but when a LoanId number is
already in the database or imported in this doesn't do anything instead it
just shows the LoanId. Is there anyway to have it always show up? I was
thinking of before update?

=Format([DateofLoanAgreementSigned],"""HELP- ""yyyy""- 0""") & [LoanId]

THanks Emma
Click to expand...

What do you want to see if there is no data in the DateOfLoanAgreementSigned
field? Perhaps you could do something like

="HELP- " & IIF(IsNull([DateOfLoanAgreementSigned], "0000",
Year([DateOfLoanAgreementSigned]) & "-0" & [LoanID]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copying and moving records 4
How will I use the function! 0
Mail Merge - displaying a conditional number of decimals 5
Problem with MS Word paragraph and character styles: format getting messed up 2
link goes crazy in 2010 works fine in 2003 1
Access 2007 Date field shows Now instead of Date 4
Query Results in a Text Box 3
VBA - (re-) Set a Table Style 2

Top