Format text in a text box

[Shawny]

Example of data in my text box: 200501
The data is text, not number.
I want to be able to reformat this data to show either the first 4 numbers, or the last 2 numbers.
It's important for me to use the format property in the form design view.
I tried @@@@spacespace
It does not work.

 

[Pat Hartman]

What would determine how the data would be displayed?

BTW, this is obviously two pieces of data, why are they stored in a single field? This violates first normal form and as you see, can be difficult to work with.

 

[Shawny]

Thanks for the reply.
The data is a code for a university for year and term. Because of particulars in this database, that is how the data must be entered. It's up to me to separate the 2 sections.
I don't understand the question what would determine how the data will be displayed.
Sometimes I want to display the 6 digit number using only the first 4 digits. Sometimes I want to display the number using only the last 2 digits.

 

[charlesandrews]

Shawny,

I have the perfect solution for you. What date, would you like the database to start from?

Watch this space ...

 

[Shawny]

Gosh folks, I'm not understanding your questions. I guess I really don't know what is going on here.
If I need a start date, maybe last year? 200401
the user can type in any code. 200403 or 200502 or022401. I just want to separate the number into 2 different sections.

 

[Rich]

you don't see the problem here I guess,
what does 022401 represent?

 

[PierreR]

See attached zip for solution.

 

[PierreR]

To understand this, look at the table, tblName, the query, qryName and the module, called basChop. The module basChop contains two functions called ChopOne and ChopTwo, referred to by the query, qryName.

 

[PierreR]

Here is a better version of the zip (with an explanation)