Re-Post - More Help With Syntax

  • Thread starter Thread starter Chris Lines
  • Start date Start date
C

Chris Lines

Guys

John Vinson and BruceM kindly gave me advice on this issue, but I failed to
make myself clear in my return posts to them and I still can't get it to
work. I have posted the issue again in an effort to resolve it.

Work has changed its format for file numbers. So, if I am looking at a
2-year-old file I would see its reference number written as ADMLH/12/34. But
if I am looking at last week's files I would see the reference number as
LH/12/34. Thanks to this forum, I have figured out a way for my files
database to cater for this change in file number format by using a validation
rule (rather than an input mask) to handle the different formats. That aspect
is working as I want it to. On advice, I am storing literal characters in my
underlying table.

I am trying to display the file reference number (could be either
ADMLH/12/34 or LH/12/34) in the header of my frmFilesDetails. The string
should result in:

Post File No: LH/12/34 ... or could be ADMLH/12/34

I am displaying the reference number by using the string:

="Post File No: " & Nz([TaskPostFileNo]," (New)")

I am using @@&&&/@@/@@ in format txtbox

But, the string is actually returning:

Post File No: lh/12/34 (or admlh/12/34).

And for " (New)" it returns Post File No: (/Ne/w)

Grateful for further advice on this one pls.

Regards

Chris
 
Sorry Fogot the second question

Try "!>@@&&&@@@@"

The ! forces it to fill from left to right

Kevin
 
kc

Thank you for both your responses. I very much appreciate them. I'll fiddle
with both and see what works best. Thanks again.

Regards

Chris

kc-mass said:
Sorry Fogot the second question

Try "!>@@&&&@@@@"

The ! forces it to fill from left to right

Kevin


Chris Lines said:
Guys

John Vinson and BruceM kindly gave me advice on this issue, but I failed
to
make myself clear in my return posts to them and I still can't get it to
work. I have posted the issue again in an effort to resolve it.

Work has changed its format for file numbers. So, if I am looking at a
2-year-old file I would see its reference number written as ADMLH/12/34.
But
if I am looking at last week's files I would see the reference number as
LH/12/34. Thanks to this forum, I have figured out a way for my files
database to cater for this change in file number format by using a
validation
rule (rather than an input mask) to handle the different formats. That
aspect
is working as I want it to. On advice, I am storing literal characters in
my
underlying table.

I am trying to display the file reference number (could be either
ADMLH/12/34 or LH/12/34) in the header of my frmFilesDetails. The string
should result in:

Post File No: LH/12/34 ... or could be ADMLH/12/34

I am displaying the reference number by using the string:

="Post File No: " & Nz([TaskPostFileNo]," (New)")

I am using @@&&&/@@/@@ in format txtbox

But, the string is actually returning:

Post File No: lh/12/34 (or admlh/12/34).

And for " (New)" it returns Post File No: (/Ne/w)

Grateful for further advice on this one pls.

Regards

Chris
Click to expand...
Click to expand...
 
Back
Top