Recent content by Parrot215

Yeah, one can color the whole data in a table or a certai field (column), but not different texts within a field. Thanks for you help, guys.

I will try it. Thanks.

Thanks, i was thinking the same thing. It can only be done thru a form. I work with data in a table. Thanks for letting me know. Johnny

Good Morning. I have a problem with my MS Access data program. I am trying to make a three word drop down menu to show one of the words in color (red) and the rest of the two words in black. Main table with the records are at: "all holds" Table for the three words are at: "Results"...

I will try your suggestion and let you know. Thanks.

Maybe I can leading zeros in the main table where the data sits? What could be a good formula for a field that contains "000 0000000.A"?

I think the query conversion part of access is where I used it. The data comes in from Excel as general or numeric. I see the problem there. The data then rests in s table which is shiot text data type. I tried the expression there in table design but the two fields are combined already. The...

Thanks for your input. I have tried that already. Nothing. I have used that expression already. The access database file was written by someone else. Once the company moved to a new online program, nothing works. I had to change the conversion headings with the new ones, and it picked up...

Good evening to you all. I have a problem I need help on. There is a field I am trying to add a leading zeroes to a fix set of numbers. I already combines the fields through a conversion query as such Field3: Table1.[Field1] & " " & [field2]. Field 1 = 112 Field 2 = 56843312...