PDA

View Full Version : custom made Message box vba code help



lrnathantrc
10-31-2007, 12:18 AM
Dear friends,

I need to show the warning messages etc., in a custom made message boxes with different font sizes and colours of the fonts. can anyone help me with the :banghead: vba code for ms access 2000 or latter for the same.

thanks in advance

bye
LRN

OTWarrior
10-31-2007, 02:13 AM
create a separate form, and dynamically change what labels/buttons are visible/invisible depending on the critera.

btw, why do you want different colours and sizes? what happens if someone has a visual impairment (colur blindness for example)?

IMO, it is easier to use the normal message boxes and just put in the words you wish to display. not only is it easier, but i think it looks more official.

what kind of message do you wish to display?

lrnathantrc
10-31-2007, 04:38 AM
Dear friend,

I am creating a form for data entry and an another form for data verification using ms access 2000 with vba code. In which If there is an error in the entry i want to display the message in the message box with value I had already succeded the same. but in the msgbox the information along with the value is displayed in the same format I want to differetiate them. that is what I need the VBA code for the same. Thanks.

bye
lrn

OTWarrior
10-31-2007, 04:44 AM
so something along the lines of:


msgbox (data1 & " is not valid" & err.Description), vbCritical, "Input Error"


data1 being the value that has been passed to it from the input on the form