Format for a field

**banpreet** · 12-22-2016, 11:41 AM

Hey guys, I posted this before on my other thread which was not the the problem but now it is.

I have a table with a field TR_ID. On the form when a new record is created it takes the last id and adds by 1 which works good. For example I create a new record and goes to 60 automatically on the form field. But how do I get "TR-" in the begging of the number so the format is "TR-60" on the form field. I tried from the other thread but didn;t work. If somebody can list step by step where to type in the information in table or field on form and what to type in. Thanks all help is appreciated!

**NightWalker** · 12-22-2016, 12:18 PM

Is the field set up as a text or number field

**banpreet** · 12-22-2016, 12:18 PM

Text field

**John_G** · 12-22-2016, 12:57 PM

...when a new record is created it takes the last id and adds by 1...

How does it do that, if the field is a text field? ID fields are normally numeric if you want to do any type of mathematical manipulation with them, and it makes using them in queries much easier.

If you want to see that ID as TR-xxx in forms, reports or queries, then you set the format to display "TR-" before the number.

On a form, set the Format property of the textbox to "TR-"000 (I know that looks a little strange, but that is what Access used when I tried it).

In a query, use the Format function: Format([TR_ID], "TR-000")

**banpreet** · 12-22-2016, 01:14 PM

Did not work, I didn't do it through a query and I tried putting that in the property tab in format and did not work, any other suggestions?

**John_G** · 12-22-2016, 01:40 PM

It didn't work -

OK, but what did it do, i.e. what did the form show in the ID textbox?

**banpreet** · 12-22-2016, 01:46 PM

it did absoluty nothing, it just showed the number like it did before

**John_G** · 12-22-2016, 02:55 PM

it did absoluty nothing, it just showed the number like it did before

Something isn't right here - I can't see why it wouldn't work. Did you change the ID field to numeric as was suggested? I don't think it's that, but it might be.

What exactly did you put in the Format property of the textbox?

**banpreet** · 12-23-2016, 09:14 AM

Ok it worked, I had to change the data type to number, Thanks a lot!

Format for a field

Thread Tools

Format for a field

Similar Threads

Format field for Min:Sec.000

Combine a date field in mm/dd/yyyy format with a text field to produce a field without the date /

Convert field like 19240525 format from .txt file to date format 05/25/1924 in access

Number Field Format.

Change field format

Posting Permissions