Recent content by Cliff67

Having previously worked for London Underground for 18 years in various engineering departments including Lifts and Escalators, the explanation by the Chief Engineer was simple "They just do, so accept it and stop asking stupid questions" . Over the years I've found out that it is really as...

have a look at this one or this one https://www.dailymail.co.uk/video/news/video-1753858/Video-Vegetarian-dog-chooses-meat-vegetables.html dogs are carnivores, giving just vegetables is damaging to their health, it's almost as bad a give a dog bread or chocolate

Thank you all for the help and information supplied. I'm marking this thread as solved.

Hi Doc_man you may be right as arnelgp does not have the bracket around the "T" &'0000' bit and it works thanks for the insite and the help

Hi Plog I tried separation them, the DMax Worked, the Format seemed to work but no idea why they don't work together. Adding arnelgp's NZ function worked. thanks for the help

Hi arnelgp that worked a treat, thanks very much

Thank you all for the replied, I'll try them tomorrow and get back to you all

Hello All, long time no post. So a lot has happened since I last posted here. I've changed jobs and I'm now in another industry altogether. I'm still putting my Access skills to use here too. I'm using Access 365 which has been a learning curve so maybe that is the issue Now down to the...

Hello All. You wont believe this, I moved the combo box a few centimeters to put another combo box to try something out and the old combo box works as expected. I'm completely lost why that would happen. Thank you all for your help.

I would but it is the design colours for all forms in this Database, it was not my first choice if I had the option. That being said this is the only form that this has happened to, I think

Hi MajP I tried that but I still seemed to get the black text

I tried a new form and the same thing happened, it's got me stumped

or start again

Yes it's a complete mystery to me. I'm thinking of coping the form with another name and see what happenss

Tried the repair - still the same. I've attached a cut down version, Open the Frm_tickets form (ignore the messages) and select from the top "Actions" then "Amend Dates. The Amend TSR is white text When you open the Frm_Repair_Main and click on the Amend button the form opens again but this time...