This is going to be an odd question because I really am new to all of this. Hopefully I understand the question as well as the answer I may get.

I am using FM7 Pro on a Mac G4 (OSX v10.3.9) I am reaching the Mac across a network to pull the database from a Windows 2000 server. I have no issues with this.

When I get the database up, I am adding new entries to it and come to a "Stock #" field. It allows me to put in any amount of numbers in it (I have tested up to 30 numbers) but no alpha characters (other than in the first position). What I want to do is take the content and put in "H-12345" or "12345H"(for example) as the Stock #.

It will allow me to put in "H12345" and although it saves the entry, it only displays "12345" until I click in the field (at which point it shows the "H"). If I put in "H-12345" it saves the data and displays "-12345". The same as the last example.

If I try to use a letter in the stock number anywhere but in the first position, it will not accept it at all.

Does anybody know how I can modify this field to allow me to put in a stock number like "H-1234H", "12345H", "12345-H" or "123J45-123".

Another thing I would like is to have it display more characters on the screen (Right now, it only displays 4).

Anyway, I inherited this database from the previous IT Manager and there is no way to reach him, so I am at your mercy to solve this.

Any help would be appreciated.

if you go into layout mode - select the field and go to Format - Number and change the format to "general" - the leading letters will show up.

You have to make the field wider on any layout that you have it (or the text smaller) to show more characters.

Thank you. I will check into this soon.